Viewing 15 posts - 10,711 through 10,725 (of 19,560 total)
Here is a list of good resources from Amazon as well.
http://www.amazon.com/lm/R3RB13PQ7D8TKB
Edit - added the list
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
March 29, 2011 at 3:39 pm
To find which procs are obsolete, you need to start logging the execution of your procs and do it for a few months (some may only be called monthly, quarterly...
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
March 29, 2011 at 2:23 pm
Read the first article in my signature (By Gail Shaw).
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
March 29, 2011 at 2:03 pm
Certainly one of the best resources is right here at SQLServerCentral.
MS uses TSQL. There are some differences between PL/SQL and TSQL, but a good foundation in SQL will help...
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
March 29, 2011 at 2:03 pm
Please post the execution plan.
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
March 29, 2011 at 1:42 pm
Daniel Bowlin (3/29/2011)
crookj (3/29/2011)
Brandie Tarvin (3/29/2011)
Tom.Thomson (3/29/2011)
Ray K (3/29/2011)
Peter Trast (3/28/2011)
'Spensive-- Ricky Ricardo
LUUUUUUUUUUUU-CYYYYYYYYYYYYY!!!
DIAMONDS
Sky
Lucy in the Sky with Diamonds - LSD
Joe
Yellow Submarine
Leningrad
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
March 29, 2011 at 9:55 am
jcrawf02 (3/29/2011)
CirquedeSQLeil (3/29/2011)
jcrawf02 (3/29/2011)
Kiara, happens to me all the time. That's why I like hanging out with people smarter than me (and Alvin), some of it rubs off. 😀
And no...
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
March 29, 2011 at 9:30 am
jcrawf02 (3/29/2011)
Kiara, happens to me all the time. That's why I like hanging out with people smarter than me (and Alvin), some of it rubs off. 😀
And no Alvin to...
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
March 29, 2011 at 9:18 am
You're welcome.
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
March 29, 2011 at 9:12 am
Thanks for taking the time to post your article and solution for this topic.
Though most wouldn't want to use a cursor or RBAR script in the database, how many use...
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
March 28, 2011 at 10:59 pm
Or you could do as ColdCoffee has written.
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
March 28, 2011 at 10:15 pm
This should do it for you
with msoffice as (
Select
Inv.Guid,
inv.Name,
inv.Domain,
inv.[User],
inv.127.0.0.1,
case when arp.Name LIKE 'Microsoft Office%'
Then arp.Name
Else ''
End as Office_Name,
case when arp.name like 'Microsoft Office%'
Then arp.Version
Else ''
End as OfficeVersion
From...
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
March 28, 2011 at 10:12 pm
jeedee (3/28/2011)
You should use table variables instead of temporary...
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
March 28, 2011 at 3:07 pm
For something like this, I would say in most cases to calculate at runtime. However, by the name of the column being used and until that particular OP changes...
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
March 28, 2011 at 2:39 pm
jeedee (3/28/2011)
Almost all the books I have read about SQL Server state that it's better to use table variables than...
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
March 28, 2011 at 2:37 pm
Viewing 15 posts - 10,711 through 10,725 (of 19,560 total)