Viewing 15 posts - 1,336 through 1,350 (of 1,583 total)
Can you post your SELECT statement?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 14, 2011 at 11:42 pm
Have you tried WITH(INDEX(IX_PartyMain_incl_AddressEntitySourceRecordType_1_to_100000000))
?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 14, 2011 at 11:03 pm
Well I wasn't able to figure out "why" this keeps happening but I was able to resolve it by manually running scome TSQL to clean up the problematic replication commands....
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 11, 2011 at 2:29 pm
@Breakwaterpc
Wouldn't you have to use OPENQUERY if the servers use NTLM authorization?
No, you wouldn't have to. However if you really wanted to you could use OPENQUERY but becomes...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 11, 2011 at 1:50 pm
Try SQLEnlight.
Highly configurable, and works pretty well (IMHO)
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 9, 2011 at 10:34 am
Is there a reason why referencing another server in my domain won't work using "FROM [servername].[dbname].[owner].[tablename]"?
Even when referencing a server with the 4-part requires a linked server. Whether...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 8, 2011 at 10:09 pm
Which version of SQL are you running this on? I ran it without error against 2008 EE...did you parse the query? Are you certain you selected all of...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 8, 2011 at 9:47 pm
Understood Jeff, but if there will be queries like that running again (safe to say that it will happen again) then wouldn't it be considered a good practice to have...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 8, 2011 at 7:50 pm
Take EVERYTHING that the SQL doctor suggests with several grains of salt.
You can take a fresh install of SQL Server with recent databases and run the Doctor and it will...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 8, 2011 at 2:53 pm
You CANNOT view this in grid mode. Each line in the grid output is a new "ROW".
See for your self, Try this:
-- Run this in "Results to Text"
SELECT 'This!'...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 8, 2011 at 1:49 pm
To reinforce NJ-DBA...
There is some reason that the file grew to 50GB. Usually we say, "leave the file as big as it grows to- if it got that big, it...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 8, 2011 at 1:27 pm
Are you outputting te results to grid or text?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 8, 2011 at 12:58 pm
Yep, you can.
If you're ever worried about data loss, take a full or differential backup before running the DBCC command
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 8, 2011 at 12:54 pm
If you're LDF files are growing and not going back to their respective sizes over time, you definitely have one of the two enabled. In fact, Full is the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 8, 2011 at 12:12 pm
Add CHAR(13)
Ex:
CASE WHEN NewTitle IS NOT NULL THEN 'HR Change for: '+ CAST(FirstName + ' ' + LastName AS varchar(100))+ CHAR(13) + ', Previous Title: '+ CAST(OldTitle AS varchar(800))+', New...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
November 8, 2011 at 12:00 pm
Viewing 15 posts - 1,336 through 1,350 (of 1,583 total)