Viewing 15 posts - 17,656 through 17,670 (of 19,560 total)
thanks for posting your update.
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
February 2, 2010 at 6:53 pm
please don't cross post. Answers and posts should be posted to
http://www.sqlservercentral.com/Forums/Topic855268-338-1.aspx#bm858349
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
February 2, 2010 at 6:52 pm
Nature of the device. Lower end SSDs are designed more for the W.O.R.M (write once read many) type of environment. Enterprise class SSDs should have less of 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
February 2, 2010 at 6:15 pm
That kind of company, they probably all invested in the business too.
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
February 2, 2010 at 6:03 pm
Edogg (2/2/2010)
A company called Social Strata in Seattle just offered its employees unlimited paid time off. Unfortunately they are not hiring. I checked...
What's the catch?
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
February 2, 2010 at 5:44 pm
The mdf will need to be restored as Steve suggested.
One other possibility is piecemeal restores - if your database is segmented into filegroups.
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
February 2, 2010 at 5:27 pm
AndrewSQLDBA (2/2/2010)
You can create a SQL Script to do that. Drop the Constraint, truncate the table and create the Constraint again. Or you can script...
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
February 2, 2010 at 5:13 pm
This link will show you how to do that.
http://msdn.microsoft.com/en-us/library/ms190255.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
February 2, 2010 at 5:09 pm
kstjacques (2/2/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
February 2, 2010 at 5:05 pm
looks to be a typo. It could be referring to a credential - but still as typed it would be a typo.
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
February 2, 2010 at 5:00 pm
Those are 2005 groups and you will not need them with 2008.
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
February 2, 2010 at 4:56 pm
Personally I would lean towards 32Gb - understanding that I don't know your environment, usage patterns, etc. That would also depend on if 64 bit Enterprise Edition is being...
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
February 2, 2010 at 4:54 pm
Yes, it looks like he is learning.
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
February 2, 2010 at 12:25 pm
I think this is an excellent idea. Make it a little better and let the family oriented employee take the family. More of a perk at that point....
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
February 2, 2010 at 12:25 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
February 2, 2010 at 12:20 pm
Viewing 15 posts - 17,656 through 17,670 (of 19,560 total)