Viewing 15 posts - 16,066 through 16,080 (of 19,560 total)
amandix (3/22/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
March 22, 2010 at 6:11 pm
I think you are creating more work for yourself and will make maintenance on the database a little more difficult.
http://www.developer.com/db/article.php/3622881/Basics-of-Statistics-in-SQL-Server-2005
That link discusses some of the workings of statistics. Statistics...
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 22, 2010 at 6:09 pm
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 22, 2010 at 6:00 pm
amandix (3/22/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
March 22, 2010 at 5:45 pm
Since you have added logging to it, that is good.
Does the stored procedure run in a transaction?
Maybe encapsulate the statements in the proc within a try...catch block and output errors...
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 22, 2010 at 5:35 pm
Jeff Moden (3/22/2010)
Gianluca Sartori (3/22/2010)
tstaker (3/22/2010)
Anyone have anything funny, interesting or weird to talk about today? I'm bored.
A consulting company here installed a SQL clustered Server with two nodes...
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 22, 2010 at 5:21 pm
amandix (3/22/2010)
Here follows step by step (SQL 2005 solution):
1. Copy the mdf and ldf of mssqsystemresource and rename both with copy in the end “mssqsystemresource_copy.mdf” and “mssqsystemresource_copy.ldf”
2. Attach this...
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 22, 2010 at 5:19 pm
The datasource is Oracle. The reportserver is obviously MS SQL. Which (source db or report db) is showing the contention/ blocking?
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 22, 2010 at 5:16 pm
The Dixie Flatline (3/22/2010)
I distinctly remember some of the odd things...
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 22, 2010 at 5:15 pm
In follow up to Waynes post, please document the Cluster Names, Node Names, Group names and let us know what they are (so proper advice can be given).
Also, it would...
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 22, 2010 at 3:54 pm
Silaphet Mounkhaty (3/22/2010)
I have two flat files that we process nightly say file1.txt and file2.txt. We process file1 at 12:45am and file2 at 4:45am nightly. The size of file1...
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 22, 2010 at 3:50 pm
Alvin Ramard (3/22/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
March 22, 2010 at 3:45 pm
The Dixie Flatline (3/22/2010)
Yes! There was a really funny Question of the Day about names.
Which one was that? I don't recall it.
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 22, 2010 at 3:43 pm
Looks fine to me. Is it not producing the desired results?
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 22, 2010 at 3:42 pm
Lynn Pettis (3/22/2010)
Probably didn't like the answers in the first post.
That was the perception I got.
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 22, 2010 at 3:39 pm
Viewing 15 posts - 16,066 through 16,080 (of 19,560 total)