Viewing 15 posts - 2,116 through 2,130 (of 3,221 total)
You might want to download and use:
Microsoft SQL Server 2008 Upgrade Advisor
Brief Description
Download the Microsoft SQL Server 2008 Upgrade Advisor. Upgrade Advisor analyzes instances of SQL Server 2000 and SQL...
February 12, 2010 at 11:32 am
whitlander
It appears that you will be handling a great deal of date data.
If you have not already found Lynn's posting may I suggest reading this post by...
February 11, 2010 at 8:04 am
There are two ways to replace the place holders ... read the following subjects in BOL
RAISERROR and/or FORMATMESSAGE.
It will not be easy and may require a great deal of...
February 10, 2010 at 3:47 pm
and not the custom error messages that I was seeing.
Refer to WayneS post, the "custom" message you receive is because the place holders described in WayneS post are replaced with...
February 10, 2010 at 3:16 pm
Using BOL for 2000 look at this:
sysmessages
Contains one row for each system error or warning that can be returned by Microsoft® SQL Server™. SQL Server displays the error description on...
February 10, 2010 at 2:44 pm
Tom.Thomson
the question say use two separate instances of SSMS or QA, and not two separate windows in one instance
If you have extensively followed the moans/groans and complaints associated with some...
February 9, 2010 at 1:04 pm
1. Assuming your back up is FULL RECOVERY. Perform a complete backup
2. Use Set ROWCOUNT to a resonable size (Start low, watch your log file size, and...
February 8, 2010 at 4:18 pm
Let me suggest you turn your thinking around.... to the question ... what data do you want out of the DB ... in the form of reports and /or someone...
February 8, 2010 at 3:19 pm
Again without a Tally table (hence not the most efficient method), but here goes.
CREATE TABLE #tTestData (MyTextCol VARCHAR(max))
INSERT INTO #tTestData( MyTextCol )
VALUES ( 'Without a doubt SQLCentral is home...
February 8, 2010 at 10:45 am
For those of you who have not seen RBarryYoung's forume post here:
http://www.sqlservercentral.com/Forums/Topic861691-4-1.aspx?Update=1
Please chime in with your thoughts/comments
February 8, 2010 at 9:06 am
RBarryYoung
Somehow we have GOT to get people to use the fr*ck#ng code tags in these forums
Second the motion
February 8, 2010 at 9:00 am
Without using a Tally table
DECLARE @What VARCHAR(200)
DECLARE @Start INT
DECLARE @End Int
SET @What = 'Sometimes things may get [SQL GETDATE()] heated[comment:#super hot debate].'
SET @Start = CHARINDEX('[COMMENT',@What,1)
SET @End = CHARINDEX(']',@What,@Start+1)
SELECT @Start,@End
SELECT...
February 8, 2010 at 8:55 am
Listen all ye to the voice of the THREAD
February 5, 2010 at 4:20 pm
JamesNZ
get a list of user-defined statistics out of a database.
Now this will give you all the statistics, other than those created is Auto_statistics is set ON. Those you should...
February 5, 2010 at 1:09 pm
Try this for each table in the DB
sp_statistics 'your table name''
Read up on sp_statistics (Books On Line)
Returns a list of all indexes and statistics on a specified table or indexed...
February 4, 2010 at 3:36 pm
Viewing 15 posts - 2,116 through 2,130 (of 3,221 total)