Forum Replies Created
Viewing 15 posts - 14,626 through 14,640 (of 19,560 total)
-
RE: Are the posted questions getting worse?
Paul White NZ (4/20/2010)
CirquedeSQLeil (4/20/2010)
I did note a few things, he still uses sysprocesses (I believe it is for the blocking process count), implements a ton of dynamic sql, uses...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 -
RE: MCJ - The Missing Link
Steve Jones - Editor (4/20/2010)
I'll check with Red Gate tomorrow. In terms of sponsorship, I think we can do something. Not sure we want to host it, but maybe we'll...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 -
RE: Are the posted questions getting worse?
Unfortunate score - really.
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 -
RE: dbgrowth
gmamata7 (4/20/2010)
I'm Using the below script in SQL Agent & running daily as a job, which writes the data file & log file used space & free space in 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 -
RE: AUDITING
This should be a good resource for you.
http://msdn.microsoft.com/en-us/library/dd392015.aspx
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 -
RE: Today's Random Word!
Tom.Thomson (4/20/2010)
John Rowan (4/20/2010)
multiplyfruitfully or arithmetically?
replenish
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 -
RE: The specified Network password is incorrect
Have you verified that the server can still communicate with AD?
Also, is the account expired or locked out?
You may need to disjoin and then rejoin the Domain.
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 -
RE: '-' in sql server
Though the brackets will correct that issue, I recommend not including special characters in server or database names (_ - etc)
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 -
RE: remove duplicate records, but keep most "current"
COldCoffee (4/17/2010)
Will the below code help you buddy??WITH MAX_DATE_FOR_A_MACHINE_CTE(MACHINE_NAME, MAX_DATE)
AS
(
SELECT
NAME
, MAX(DATE) MAX_DATE
...
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 -
RE: How much a support call to MS cost?
It depends on your support contract with them. You should contact them directly to find out.
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 -
RE: Index Rebuild Order
Many indexes only need to have a Reorg performed on them.
There is a great script for doing this by Michelle Ufford, here[/url].
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 -
RE: dm_db_index_usage_stats - Multiple entries for a single index
I would not expect this behavior. I haven't been able to reproduce the behavior. When was the last time you updated your statistics? Rebuilt indexes?
Also, what is...
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 -
RE: Will view imporve performance
Grant has made an excellent suggestion.
You should find the queries that are slow, evaluate their execution plans and then tune the queries and indexes from 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 -
RE: Using IDENTITY as a key column
pjdiller (4/20/2010)
Now, I'm not convinced that this is the last word, but I wanted to describe the cause for my confusion. How do I create an insert statement 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 -
RE: MCJ - The Missing Link
Lynn Pettis (4/20/2010)
Can someone try and touch bases with Steve? It was suggested to see if RedGate might be willing to sponser this community endeavour, and since he works...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
Viewing 15 posts - 14,626 through 14,640 (of 19,560 total)