Viewing 15 posts - 41,941 through 41,955 (of 49,571 total)
madhu.arda (1/6/2009)
If I do DBCC TRACEON(1222,-1), the trace will be on for ever?
Until you turn it off (DBCC TRACEOFF(1222,-1)) or until the SQL service is restarted.
January 6, 2009 at 3:16 pm
Continued here - http://www.sqlservercentral.com/Forums/Topic630987-169-1.aspx
No more replies to this thread please.
January 6, 2009 at 2:53 pm
markmeiller (1/6/2009)
January 6, 2009 at 2:51 pm
This might help you
http://sqlinthewild.co.za/index.php/2007/11/05/datetime-manipulation/
If you want to ensure that the data inserted has no time, you'll either need a trigger (which is the more complex and probably slower route), or...
January 6, 2009 at 2:44 pm
Please post SQL 2000-related questions in the SQL 2000 forums. If you post in the 2005 forums, you're very likely to get 2005-specific solutions.
The Information schema exists in 2000 as...
January 6, 2009 at 1:42 pm
A view doesn't store data. It's just a saved SQL statement. So, when you change the data in the table, it will immediately reflect in the view, just as it...
January 6, 2009 at 1:41 pm
GSquared (1/6/2009)
January 6, 2009 at 1:38 pm
madhu.arda (1/6/2009)
we need to add this trace file in sartup parameters in configuration manager or there is another way to do it?
DBCC TRACEON(1222,-1)
and I did not add the trace 1204...
January 6, 2009 at 1:37 pm
Franco_1 (1/6/2009)
In SQL Server Management Studio query pane, I had to actually pass in string values for it to work,...
January 6, 2009 at 1:25 pm
Since it's SQL 2005, can you get the deadlock graph using traceflag 1222 instead of 1204 please? The information's a lot more detailed and far easier to read.
January 6, 2009 at 1:01 pm
nitinpatel31 (1/6/2009)
By the way sql server uses nested loops and indexnested loops join.
Not true. Nested loops, merge and hash are the three algorithms that SQL uses to do joins. Nested...
January 6, 2009 at 12:57 pm
For a summary: http://sqlinthewild.co.za/index.php/2007/12/30/execution-plan-operations-joins/
For the really technical details, follow the links on that page.
January 6, 2009 at 12:55 pm
Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic630887-1063-1.aspx
January 6, 2009 at 12:54 pm
RBarryYoung (1/6/2009)
GilaMonster (1/6/2009)
Grant Fritchey (1/6/2009)
I must be old, D&D used lots (and lots and lots) of six-sided dice. Now, Traveller, there were the decimal dice at work.
Which edition was that?...
January 6, 2009 at 12:51 pm
GSquared (1/6/2009)
January 6, 2009 at 12:49 pm
Viewing 15 posts - 41,941 through 41,955 (of 49,571 total)