Viewing 15 posts - 16,291 through 16,305 (of 19,560 total)
The Dixie Flatline (3/17/2010)
Did somebody order a babelfish?
Yup:-D:-D:-D
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 17, 2010 at 10:47 pm
Paul White (3/17/2010)
DECLARE @command VARCHAR(MAX),
@script VARCHAR(MAX);
SET @command =
...
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 17, 2010 at 10:44 pm
Here is a script I have used in the past. Check it out.
http://www.mssqltips.com/tip.asp?tip=1818
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 17, 2010 at 10:41 pm
tvu4251 (3/17/2010)
I found those out too, going through each of them.
luckily, I have and will try the Red Gate X-SQL bundle.
Hopefully, it will save me...
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 17, 2010 at 10:37 pm
Jeffrey Williams-493691 (3/17/2010)
tvu4251 (3/17/2010)
this is for a customer that is anxious to try sql2008, but the app is not quite 100% upgradable yet.
So, one of your customers upgraded to SQL...
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 17, 2010 at 10:17 pm
Sergiy (3/17/2010)
🙂
These 2 statements contradict each other:
On the other side an Oracle DB, also with staff, but only active.
when a staff member leaves...
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 17, 2010 at 9:46 pm
Alvin Ramard (3/17/2010)
CirquedeSQLeil (3/17/2010)
We see several people complaining about the English in the QOD. What if we responded to all QOD comments for a...
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 17, 2010 at 9:43 pm
sudhakara (3/17/2010)
Hi...Can anyone share me the Best Practices for Applying Service Packs and Hotfixes in sql server 2005 ?
Thanks in Advance
The best practice is to install them in a...
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 17, 2010 at 9:39 pm
A thought just occurred to me.
We see several people complaining about the English in the QOD. What if we responded to all QOD comments for a given time period...
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 17, 2010 at 9:18 pm
Thank you.
This is a good refresher and important topic.
Good question
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 17, 2010 at 9:15 pm
GoGreen (3/17/2010)
Thanks for reply to all..I found the issue it was due to how SQL string is created in my program....
Which uses much of resources...
thanks for letting us know.
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 17, 2010 at 9:12 pm
I suggest two more things before starting any of that.
1. Backup the database
2. Disable access to the server for all connections not related to you, the team, or...
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 17, 2010 at 9:09 pm
John Langston (3/17/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 17, 2010 at 8:09 pm
Lynn Pettis (3/17/2010)
john.arnott (3/17/2010)
gamcall (3/17/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 17, 2010 at 8:06 pm
Alvin Ramard (3/17/2010)
CirquedeSQLeil (3/17/2010)
Has anybody heard any news about Barry's surgery?
No, but why don't you use TimeWarp to go forwards to the day he comes back and see what he...
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 17, 2010 at 6:34 pm
Viewing 15 posts - 16,291 through 16,305 (of 19,560 total)