Viewing 15 posts - 4,696 through 4,710 (of 19,560 total)
fivetenmm (4/19/2013)
The automated backups stopped running over a month ago b/c the log files kept growing and maxed out the space on the RAID 5 array.
Do you have any...
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
April 19, 2013 at 7:35 pm
What is the recovery model of the databases?
Definitely not a Best Practice, but you can add a usb or sata drive and backup to 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
April 19, 2013 at 5:46 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
April 19, 2013 at 4:52 pm
Here are a few resources that would be of benefit to you in trying to learn about indexes
http://www.sqlservercentral.com/stairway/72399/
And
http://www.sqlservercentral.com/articles/Indexing/68439/
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
April 19, 2013 at 4:49 pm
Other considerations besides just moving the files (code should be fine that you provided)
Consider the size of the files
Consider more files than just the default 1 data file
Consider the growth...
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
April 19, 2013 at 4:46 pm
Jeff Moden (4/19/2013)
DevDB (4/19/2013)
very good information :-http://www.brentozar.com/archive/2012/08/sql-server-dba-interview-qa-part-answers/
I love some of those questions. One of my favorites is...
9. I’m a manager, and you’re my Senior DBA. Explain to me why...
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
April 19, 2013 at 4:42 pm
Let's start with this article. I am not sure the figure correlates to bytes or bits for that matter.
http://msdn.microsoft.com/en-us/library/ms176029.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
April 19, 2013 at 4:26 pm
David.Poole (4/19/2013)
I'm going to say something contraversial here. You can do cold hard financial logical analysis of cost vs benefits and put forward a recommendation but if your business...
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
April 19, 2013 at 3:59 pm
Jeffrey Williams 3188 (4/18/2013)
But...what if truncate doesn't actually remove everything that was there before? Don't we have to be sure we delete it before we insert? :w00t:
Obviously truncate...
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
April 19, 2013 at 3:48 pm
How much free space is in tempdb data files?
How much free space in in the tempdb log file?
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
April 19, 2013 at 3:45 pm
How does the tempdb log look?
Is it set to autogrow as well?
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
April 19, 2013 at 3:43 pm
Sean Lange (4/19/2013)
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
April 19, 2013 at 2:09 pm
Thanks Hugo. Good 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
April 18, 2013 at 10:29 pm
It is one thing to ask for questions. It is an entirely different thing to ask for the answers to those questions.
Getting an idea of questions to be asked...
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
April 18, 2013 at 2:10 pm
opc.three (4/18/2013)
bcsims 90437 (4/18/2013)
SQLRNNR (4/18/2013)
JAZZ Master (4/18/2013)
crookj (4/18/2013)
opc.three (4/17/2013)
SQLRNNR (4/17/2013)
JAZZ Master (4/17/2013)
Revenant (4/17/2013)
SQLRNNR (4/17/2013)
opc.three (4/17/2013)
Stuart Davies (4/17/2013)
Evil Kraig F (4/16/2013)
SQLRNNR (4/16/2013)
UniverseEgos
Id
Sequence
helix
double
mint
truffle
Fries
Chili Cheese...
hot dogs
ANGUS
KOBE
Achilles
:crying:
Ouch
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
April 18, 2013 at 11:19 am
Viewing 15 posts - 4,696 through 4,710 (of 19,560 total)