Viewing 15 posts - 8,401 through 8,415 (of 19,560 total)
Same principle - you will get a performance gain but it will only be less of an impact.
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
October 5, 2011 at 8:36 am
For more info check the links in my sig for Kimberly Tripp.
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
October 4, 2011 at 10:24 pm
If you are seeing an avg_user_impact of 1000, then adding the appropriate index could improve your query performance by 10x. If a query takes 1 second to run with...
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
October 4, 2011 at 10:09 pm
What method are you currently using to create your file name?
Add a variable with the datetimestamp and an expression on the filename of your excel output.
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
October 4, 2011 at 10:06 pm
What is the error you get when trying to backup your logs?
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
October 4, 2011 at 10:02 pm
It's by design. Expanding a column does not require the truncation of data. Call it a safety measure enforced by Microsoft when you reduce the size 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
October 4, 2011 at 10:00 pm
My favorite method of those listed is to use SSIS if you are looking to automate 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
October 4, 2011 at 9:55 pm
As per the best practice for SSRS - if you have resource intense reports and the reports are being hit constantly, then it is recommended to put SSRS on 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
October 4, 2011 at 9:45 pm
The best way to determine if SSRS is installed (and not just a reportserver database restored to that instance), is to check the services. If the SQL Reporting Service...
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
October 4, 2011 at 9:43 pm
L' Eomot Inversé (10/4/2011)
SQLRNNR (10/4/2011)
Dude63 (10/4/2011)
Ray K (10/4/2011)
crookj (10/4/2011)
Daniel Bowlin (10/4/2011)
Resistance is futileConfrontation is inevitable
Evidence is indisputable
Corruption taints evidence
Emotion taints evidence
Policy taints evidence
Thus evidence taints truth (if emotion, policy 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
October 4, 2011 at 6:15 pm
Fal (10/4/2011)
She had a maths problem like “102 + 44 + 266 + 78...
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
October 4, 2011 at 6:13 pm
L' Eomot Inversé (10/4/2011)
Gianluca Sartori (10/4/2011)
OzYbOi d(-_-)b (10/4/2011)
L' Eomot Inversé (10/4/2011)
Good question.I guess I'm glad that I don't know this answer from experience, just from reading.
My thoughts...
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
October 4, 2011 at 6:10 pm
Thanks for the 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
October 4, 2011 at 5:14 pm
Have you run a profile or trace when running the report?
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
October 4, 2011 at 2:03 pm
Panoply, eversions, cubes, dbcc timewarp
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
October 4, 2011 at 1:56 pm
Viewing 15 posts - 8,401 through 8,415 (of 19,560 total)