Viewing 15 posts - 10,906 through 10,920 (of 19,560 total)
Mirroring is considered HA. If you mirror across separate locations, you have created an opportunity where your mirrored database can be brought up at the secondary site in case...
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 2, 2011 at 12:32 am
Here is the link that has the info on the default values for those fields.
http://msdn.microsoft.com/en-us/library/bb934197.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
March 2, 2011 at 12:08 am
Are we sure about that answer?
http://msdn.microsoft.com/en-us/library/bb934013.aspx States:
" Disabling Resource Governor has the following results:
All existing workload group and resource pool settings are reset to their default values.
"
The default values for...
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 2, 2011 at 12:07 am
Fal (3/1/2011)
David Benoit (3/1/2011)
Grant Fritchey (3/1/2011)
Well do you want video or just pictures?Just don't put either on The Thread. Please... 😀
Hey, I thought only code was barred on The Thread?
Hmmm,...
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 1, 2011 at 11:55 pm
There is a good article on the topic of file growth and how to find the root cause.
Check out this article [/url]for some more ideas.
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 1, 2011 at 11:04 pm
Table data is either in the Clustered Index (CI) or in a heap thus I shortcutted it to CI/Heap.
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 1, 2011 at 4:17 pm
With the view being indexed, you have essentially materialized the data into a CI and thus you will see those performance gains because the data is in the CI 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 1, 2011 at 3:55 pm
based on info provided:
Select textboxes52 + textboxes72 as SumTextBoxes
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 1, 2011 at 3:38 pm
Is the view and indexed view?
Also, is your logic between the view and the table joins the same (same filters in the where applied 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
March 1, 2011 at 3:35 pm
Looks like you probably have a bunch of inceptiondate values that are null.
It also looks like your policyids are null in quite a few instances thus making the queries work...
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 1, 2011 at 3:03 pm
Backup and restore your databases from the current server to the new server.
You will need to migrate security (logins, users, certs,roles, proxies etc)
You should script out your jobs and recreate...
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 1, 2011 at 2:53 pm
crookj (3/1/2011)
CirquedeSQLeil (3/1/2011)
John Rowan (3/1/2011)
Sun + gods = Golf godsThey must be Crazy
Coke Bottle! 😀
Joe
Empty
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 1, 2011 at 2:48 pm
Indianrock (3/1/2011)
CirquedeSQLeil (3/1/2011)
Indianrock (3/1/2011)
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 1, 2011 at 2:33 pm
nevermind, I see that the answers are inline in the quote.
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 1, 2011 at 2:26 pm
Indianrock (3/1/2011)
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 1, 2011 at 2:12 pm
Viewing 15 posts - 10,906 through 10,920 (of 19,560 total)