Trouble backing up our SQL Server transaction logs
Sounds like your database is in SIMPLE recovery mode. Databases in SIMPLE recovery mode can not have there transaction log backed up, as the transaction log is truncated each time the database flushes the log changes to disk. In order to backup the transaction log for this database you will need to change the database [...]

View Answer   |  February 10, 2009  6:18 AM
SQL Server backup, SQL Server backup and restore, SQL Server transaction logs

Microsoft SQL Server certification – Exams 70-432, 70-433 and 70-448
I used real world experience working with SQL Server 2005/2008 to pass the exams. When I took the exams there were no study guides available. Shortly there will be some new books coming out which I wrote part off. They will be published by Syngress Press.

View Answer   |  February 9, 2009  10:34 PM
Certifications, Exam 70-432, Exam 70-433, Exam 70-448, Microsoft certifications, SQL Server certifications

PL/SQL – Attribute to test not null and can take specific value instead
I’m not sure if I understand correctly your question. If you want to assign some specific value to a varibale or parameter in PL/SQL when it is null, you could use the NVL function, this way: <pre>l_variable := nvl(l_variable,’-');</pre> If this is not what you meant, please provide more information and examples if possible.

View Answer   |  February 9, 2009  3:31 PM
NOT NULL, NULL, Oracle development, Oracle PL/SQL, PL/SQL, PL/SQL procedure

SQL+ running time error
This could be a permissions problem in vista. Make sure you have write access to the location where you want to create the spool file.

View Answer   |  February 9, 2009  3:19 PM
SQL, SQL error messages, SQL Plus, Windows XP

Copying view from remote to local SQL Server with SSMS
There isn’t really an easy way to script out the views automatically. Unless you are changing them all that often you shouldn’t need to back them up all that often. Also your ISP should be backing up the database for you so that it can be restored from tape in case of a problem. If [...]

View Answer   |  February 8, 2009  8:20 PM
SQL Server 2000, SQL Server 2000 migration, SQL Server 2008, SQL Server 2008 administration, SQL Server Enterprise Manager, SQL Server Management Studio, SQL Server Management Studio 2008, SQL Server migration, SQL Server views, SSMS 2008

SQL Server 2005 Text Function
Which text function are you using to perform this lookup? Some of them will not perform as you would expect. If you can post some sample code to the comments section below that would be very helpful.

View Answer   |  February 6, 2009  9:50 PM
SQL Server 2005, SQL Server performance, SQL Server Query, SQL Server Text Function

Error message when restoring a SQL Server database
You are trying to restore a database to SQL Server Express which is to large to attach to a SQL Express database. SQL Server Express edition has a size limit of 4 Gigs. You are trying to restore a database which is larger than this. You will need to shrink the database then back it [...]

View Answer   |  February 6, 2009  7:46 PM
SQL Server backup and restore, SQL Server database, SQL Server error messages, SQL Server restore

Performance of very large SQL Server table with millions of rows
Without more information about the schema of BigTable I’m not going to be able to give you a good answer. If the values in the columns on BigTable will all exist for all the rows then it is probably an OK design. If the rows which have parents in TableA have different columns filled out [...]

View Answer   |  February 6, 2009  2:07 AM
Database design, SQL Server administration, SQL Server database design and modeling, SQL Server maintenance, SQL Server performance, Very Large Databases

Pulling multiple values in the same line in SQL
Doing this requires the use of a function. Something like this. <pre>CREATE FUNCTION YourFunction (@UserId varchar(10)) RETURNS VARCHAR(4000) BEGIN DECLARE @Return VARCHAR(4000) SET @Return = ” DECLARE @error_code VARCHAR(10) DECLARE cur CURSOR FOR SELECT Error_code FROM YourTable WHERE UserId = @UserId OPEN cur FETCH NEXT FROM cur INTO @error_code WHILE @@FETCH_STATUS = 0 BEGIN SET [...]

View Answer   |  February 6, 2009  1:49 AM
SELECT statement, SQL, SQL Query

SQL Server Query Help Needed
How about a UNION of two queries, one from sales,transactions (shipments) and the other from purchases,transactions (receivings) ?

View Answer   |  February 5, 2009  11:35 PM
INNER JOIN, JOIN statement, LEFT JOIN, RIGHT JOIN, SQL, SQL queries, SQL Query, SQL Server development, SQL Server Query

Why does my SQL Trigger malfunction?
Try removing the quotes from this line: <pre>@message = ‘@Body’</pre> i.e. <pre>@message = @Body</pre>

View Answer   |  February 5, 2009  7:02 PM
SQL Server, SQL Trigger

To retrieve records from SQL Server database
This is not clear enough, at least for me. I’m not sure whether you want to get records like ‘cleaning’ or not. If you want to get only records containing the word ‘lean’, then you should use something similar to this: <pre>SELECT name FROM table WHERE name like ‘lean %’ or name like ‘% lean’ [...]

View Answer   |  February 5, 2009  2:38 PM
Query optimization, SQL, SQL Server development, SQL Server Query

How to make installer of VB.NET including SQL Server 2000?
Is SQL Server already installed? What is in the connection string when you are trying to connect? this is my connect function to connect with database, I think there is problem with this coding. Please can you help. Public Sub connect() sconn = “Data Source=SUJAL;Initial Catalog=staff;User ID=sa;Password=longtail” scon = New SqlClient.SqlConnection(sconn) scond = New SqlClient.SqlCommand [...]

View Answer   |  February 5, 2009  3:50 AM
Database connectivity, Setup and deployment, SQL Server 2000, VB Setup File, VB.NET, Visual Basic, Visual Basic .NET

Why and how to performance tune SQL Server 2005
Hello, SQL Server is the engine for databases, which live on an Operating System, which interfaces the Server’s hardware. Each of these components (SQL, OS, Hardware) are highly configurable, but this flexibility can lead to incorrect, or inappropriate choices. Imagine you have a car with a fast engine and aerodynamic body, but doesn’t have any [...]

View Answer   |  February 4, 2009  8:59 PM
SQL Server 2000, SQL Server 2005, SQL Server performance tuning

sqldumper
try to check it in task manager then processes and see if it consumes more memory

View Answer   |  February 4, 2009  3:08 AM
SQL, sql dumper, SQL performance, SQL Server memory, SQL Server performance

Configuring a SQL Server to optimize for best performance
The only way to truly optimize performance is to monitor (using perfmon/profiler) and test. You need someone with the expertise to do this, or someone who can learn the rudimentary tools and give it a shot. But, I would recommend either hiring a consultant (I can give some recommendations) or maybe using Microsoft’s “health checkup” [...]

View Answer   |  February 2, 2009  10:51 PM
ODBC, SQL Server 2005, SQL Server performance, SSMA, Sybase, Windows Server 2003, Windows Server 2003 R2

Scheduling a Shrink Database in SQL Server 2000
Yes, you can simply add another job step to use the DBCC SHRINKFILE statement. However it is typically recommended that you not shrink the files on a regular basis. Doing so causes the database engine and disk subsystem to do extra work that it doesn’t need to do. If the log has grown to that [...]

View Answer   |  February 2, 2009  8:31 PM
SQL Server 2000, SQL Server backup, SQL Server Shrink Database, SQL Server transaction logs

Data updation issues in a SQL Server table
If you have a primary key in your table that is messed up that corresponds to a value in the other table then yes you can. You may want to look a Lumigents Log Explorer and simply roll back the incorrect statement (will only work if your database is in full recovery mode).

View Answer   |  February 2, 2009  8:20 PM
SQL Server Data Validation, SQL Server databases, SQL Server tables

Dumping a table in a SQL Server database
Please provide more details. What exactly do you mean by dump (Select *)? What do you want the text for? Thanks!

View Answer   |  February 2, 2009  8:08 PM
SQL Server databases, SQL Server tables

Removing a node from a working SQL Server 2005 cluster
With the node removed the system won’t have any performance impact it will only impact the high availability of the system. I would recommend replacing the node as soon as you can.

View Answer   |  February 2, 2009  8:04 PM
SQL Server 2005, SQL Server clustering, SQL Server performance