Viewing 15 posts - 19,156 through 19,170 (of 19,560 total)
GSquared (11/12/2009)
Kit G (11/12/2009)
Bob Hovious 24601 (11/12/2009)
I've been trying to keep my mind out of the gutter, thank you very much.To some, or for some, the gutter is an improvement.
Guilty!
(I...
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
November 12, 2009 at 1:11 pm
Alvin Ramard (11/12/2009)
CirquedeSQLeil (11/12/2009)
amazing how the thread can make a day go from bad to better. At least one good laugh a day.
At first I thought you said 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
November 12, 2009 at 1:09 pm
WhatDoughHeadUsesAVGinPlaceofSumWhenTryingtoGetASum
I figured i could use my new column name as a word since that is what I have been fixing in an executive report lately.
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
November 12, 2009 at 1:07 pm
Silverfox (11/12/2009)
Must be an american recruiter 😛
what wrong with we Americanz english? (JK)
Give the recruiter a break, it's not his fault there are so many exceptions to the rules (english...
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
November 12, 2009 at 1:02 pm
Nice question. My first inclination was to go with the foreach loop container (having done that before quite effectively) - but it was worth verifying what the multiflatfile does...
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
November 12, 2009 at 12:54 pm
amazing how the thread can make a day go from bad to better. At least one good laugh a day.
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
November 12, 2009 at 12:45 pm
Jeff Moden (11/11/2009)
Ian Scarlett (11/11/2009)
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
November 11, 2009 at 3:23 pm
I'll second Jack on the DTA. DTA isn't always accurate in the suggested indexes/statistics that it suggests.
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
November 11, 2009 at 10:12 am
Greg Edwards-268690 (11/10/2009)
Alvin Ramard (11/10/2009)
GSquared (11/10/2009)
Steve Jones - Editor (11/10/2009)
Hammers aren't fun for technical equipment on the fritz. Now a slingshot.....Depends on how you define the word "hammer"[/u].
The one...
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
November 11, 2009 at 9:59 am
teletravaille
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
November 11, 2009 at 9:51 am
select u.name as UserName,o.name as ObjectName from sys.sysobjects o
inner join sysusers u
on u.uid = o.uid
where [type] = 'u'
This will get you the ObjectOwner
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
November 9, 2009 at 5:16 pm
Good Article with useful info. Thanks
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
November 9, 2009 at 4:52 pm
rlondon (11/9/2009)
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
November 9, 2009 at 4:08 pm
Visioconference
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
November 9, 2009 at 3:58 pm
the script repository here at SSC also has some scripts that would be of use. Check those out too. Download a few and find the one you like...
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
November 9, 2009 at 3:54 pm
Viewing 15 posts - 19,156 through 19,170 (of 19,560 total)