Viewing 15 posts - 16,546 through 16,560 (of 19,560 total)
Paul White (3/12/2010)
CirquedeSQLeil (3/12/2010)
I think the disconnect reconnect method is about the best way to refresh it. It seems to be most consistent for me.
Jason...CTRL + SHIFT + R!...
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 12, 2010 at 1:04 am
The current admin account, are you referring to an account in the format of a domain account (yourdomain\yourlogin)? Or did you type in 'SA' for the user account and...
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 12, 2010 at 1:00 am
Nice 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
March 12, 2010 at 12:34 am
Paul White (3/12/2010)
jmatayoshi (3/11/2010)
both answers 2 and 4 are almost the sameThat statement makes my head spin.
Hah - Paulpatine spinning like the MCP before Tron obliterates it with 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
March 12, 2010 at 12:31 am
Books Online
There are also some good books/resources in the Books section here at SSC.
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 12, 2010 at 12:26 am
Is this server clustered or a VM?
Try the following if clustered:
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 12, 2010 at 12:23 am
dheer (3/11/2010)
select DATEDIFF(mm,'10/1/2009','1/1/2010') gives us 3
because its taking the diff of...
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 12, 2010 at 12:05 am
I think the disconnect reconnect method is about the best way to refresh it. It seems to be most consistent for 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 12, 2010 at 12:01 am
Straightforward answer for a straightforward question.
Thanks.
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 11, 2010 at 11:34 pm
Even if this must be done in a prod environment, you may be able to use the shrinkfile and do it in chunks. Of course pay attention to performance...
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 11, 2010 at 11:32 pm
Some of the things we have done include:
Paintball
Kart Racing
Basketball
Nerf Guns
Throwing a football around
Chair races around the office
Miniature Golf
It may be a little relaxed to do things like that, but 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 11, 2010 at 11:12 pm
This is referring to partitioned tables. You may need to select the partitioning options in DTA.
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 11, 2010 at 9:16 pm
Grant Fritchey (3/11/2010)
Maybe it's getting updated for 2008. 2005 is getting just a tad long in the tooth at this point. I might suggest an alternativeI
I
I
I
\/
Where...
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 11, 2010 at 7:40 pm
I agree with Gail here.
If you restored the system databases, then any server scoped DDL triggers would have been restored. If you restored User databases, then database scoped DDL...
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 11, 2010 at 6:05 pm
4data (3/11/2010)
Simply as the system administrator.Should I try something else?
That is 'sa' from SSMS, right?
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 11, 2010 at 5:35 pm
Viewing 15 posts - 16,546 through 16,560 (of 19,560 total)