Viewing 15 posts - 14,911 through 14,925 (of 19,560 total)
Have you looked at the TSQL to optimize the code? The problem you are encountering seems to be a problem in a poorly written query. You need 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
April 13, 2010 at 8:58 pm
WayneS (4/13/2010)
CirquedeSQLeil (4/13/2010)
Oddity in the forums. I just noticed that I lost 27 points today. Am curious where they could have gone.
The entity known as "The Thread" randomly...
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
April 13, 2010 at 8:54 pm
I didn't see this - until after the deadline for TSQL Tuesday.
Is this something you will be doing each month? It might be good to get it out there...
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
April 13, 2010 at 7:48 pm
You can try connection_id which is a uniqueidentifier. The login_time is not technically the same as start_time since a request can contain spawned processes that start at different times.
Caution...
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
April 13, 2010 at 7:42 pm
I agree with Elliott. Yes - learn SSIS. .Net is useful in many ways, and SSIS is useful for dataflow type tasks.
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
April 13, 2010 at 7:37 pm
Oddity in the forums. I just noticed that I lost 27 points today. Am curious where they could have gone.
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
April 13, 2010 at 6:37 pm
Did this thread disappear from the forum listing? I couldn't find it without having done a search.
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
April 13, 2010 at 6:34 pm
You're welcome.
I hope it helps.
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
April 13, 2010 at 6:24 pm
I agree with Wayne. I am fine with development being a sandbox for the developers - so long as proper checks and constraints are in place to pass code...
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
April 13, 2010 at 6:24 pm
Yes, the permission can be granted to all in a single statement. However, the preferred method is on a proc by proc basis.
You should speak with the administrator that...
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
April 13, 2010 at 6:02 pm
T¦«
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
April 13, 2010 at 5:58 pm
As for the covering index vs. include topic, I would recommend reading an article by Josef Richburg and the ensuing discussion on the topic. You can find the article...
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
April 13, 2010 at 5:50 pm
Start Here:
http://msdn.microsoft.com/en-us/library/dd758814.aspx
Then check this one out
http://technet.microsoft.com/en-us/library/cc966534.aspx
Here is a recommendation by Buck Woody (MS Employee knows his stuff)
Another one by Denny Cherry (higher level disk config)
http://searchsqlserver.techtarget.com/tip/Optimize-disk-configuration-in-SQL-Server
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
April 13, 2010 at 5:44 pm
For the tempdb questions, I recommend you check out Kimberly Tripps blog. You can find a link to her blog in my signature. Browse her articles on tempdb.
As...
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
April 13, 2010 at 5:38 pm
¿
++
++
SFOp
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
April 13, 2010 at 5:34 pm
Viewing 15 posts - 14,911 through 14,925 (of 19,560 total)