Viewing 15 posts - 14,011 through 14,025 (of 19,560 total)
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
May 14, 2010 at 11:15 am
Stefan Krzywicki (5/14/2010)
CirquedeSQLeil (5/14/2010)
Last night a little dancer came dancin' to my...
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
May 14, 2010 at 11:14 am
john.arnott (5/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
May 14, 2010 at 11:11 am
For those that have syndicated blogs here, how does one get their Avatar to display on the blog page? I have an avatar assigned that shows up in comments...
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
May 14, 2010 at 11:10 am
When using the AS to alias a Table, it makes it more clear to anybody coming after you to read what your intent was.
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
May 14, 2010 at 11:05 am
Lollipop
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
May 14, 2010 at 11:04 am
Most useful to me would be an improved search and categorization. The ability to perform an advanced search and limit results based on certain criteria would be useful. ...
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
May 14, 2010 at 11:03 am
I just got an interesting perspective on the certification process last night during our UG meeting. One of the attendees works in a training center and administers the cert...
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
May 14, 2010 at 10:32 am
Chad Crawford (5/14/2010)
I just crossed 2K, wahoo! This seemed to be an appropriate place to celebrate becoming "Crazy" 🙂Chad
Congrats (on being crazy)
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
May 14, 2010 at 8:42 am
hmi (5/14/2010)
Not any SQL developer with some common sense would name a table [where] nor would invent the alias [flag...
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
May 14, 2010 at 8:15 am
Chris Morris-439714 (5/14/2010)
GilaMonster (5/14/2010)
Chris Morris-439714 (5/14/2010)
Anybody with the initials JC is doomed to have uncompetitive people skills but this guy really takes the biscuit.
Apparently he's actually a very nice...
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
May 14, 2010 at 8:13 am
Paul White NZ (5/14/2010)
CirquedeSQLeil (5/13/2010)
Thanks Gianluca. I particularly like how Paul handled this...
You would have loved my first draft reply 😉
Celko is undoubtedly a reasonably bright individual, but his...
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
May 14, 2010 at 8:07 am
That is a very broad question.
Start by finding your queries that are performing poorly and optimize them.
Load test the server
Have somebody perform applications testing against the database to ensure 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
May 13, 2010 at 11:04 pm
I think the results on this should be expected. I think the query was written interestingly enough.
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
May 13, 2010 at 10:56 pm
Here is another alternative as well.
Select object_name(a2.object_id) as ModuleName,(SELECT definition AS [processing-instruction(definition)]
FROM sys.all_sql_modules a1
Where a1.object_id = a2.object_id
FOR XML PATH(''), TYPE
) as ModuleText
From sys.all_sql_modules a2
Where ObjectProperty(a2.object_id,'IsMsShipped') = 0
Order By ProcName
This will...
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
May 13, 2010 at 6:43 pm
Viewing 15 posts - 14,011 through 14,025 (of 19,560 total)