Viewing 15 posts - 11,416 through 11,430 (of 19,560 total)
GSquared (11/4/2010)
Geoffrey Wrigg (9/3/2010)
SQL Server DBA on the prowl at a singles bar:SELECT Date
FROM Clientele
WHERE Attached = 'FALSE'
ORDER BY BloodAlcoholContent DESC
😛
And the execution plan for that is some sort of...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 15, 2010 at 8:24 am
Brandie Tarvin (12/15/2010)
CirquedeSQLeil (12/15/2010)
da-zero (12/15/2010)
I must say, today's newsletter from SSC has a really interesting advertisement for an even more interesting book.:rolleyes:
Agreed on the interesting advertisement. Is the book...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 15, 2010 at 8:20 am
dup post
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 15, 2010 at 8:14 am
dcode (12/15/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 15, 2010 at 8:13 am
Stefan Krzywicki (12/15/2010)
GilaMonster (12/15/2010)
Chris Morris-439714 (12/15/2010)
I *think* Gail has blogged on this, will look.http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/
http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/
http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/
http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/
http://sqlinthewild.co.za/index.php/2010/04/27/in-exists-and-join-a-roundup/
So that is a "yes" then? : -)
Nah - that's still up in the air 😀
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 15, 2010 at 8:13 am
da-zero (12/15/2010)
I must say, today's newsletter from SSC has a really interesting advertisement for an even more interesting book.:rolleyes:
Agreed on the interesting advertisement. Is the book bad?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 15, 2010 at 8:08 am
I would start looking at procs that provide similar data. You need to familiarize yourself with the data in your database - look at tables, keys, relationships and data...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 14, 2010 at 7:40 pm
Stefan Krzywicki (12/14/2010)
If I run the process with around 15 days in the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 14, 2010 at 7:32 pm
Anything that you did - undo it.
Then go back and read those articles that I listed.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 14, 2010 at 3:09 pm
ASDL (12/14/2010)
WayneS (12/14/2010)
ASDL (12/14/2010)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 14, 2010 at 3:07 pm
I would lean to those lines of code should be commented out. They are not proper SQL syntax.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 14, 2010 at 2:59 pm
Plan your resources ahead of time (e.g. max memory for sql server).
You will need to have new volumes with different drive letters than the volumes on the first cluster in...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 14, 2010 at 2:56 pm
I recommend putting them back. Then look up these articles.
Move system databases:
http://msdn.microsoft.com/en-us/library/ms345408.aspx
Move user databases:
http://msdn.microsoft.com/en-us/library/ms345483.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 14, 2010 at 2:51 pm
I would avoid the Select * method. Are you absolutely certain that all of the code has been adapted to properly handle all of the columns? Do you...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 14, 2010 at 2:49 pm
Which files did you move?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 14, 2010 at 2:32 pm
Viewing 15 posts - 11,416 through 11,430 (of 19,560 total)