Viewing 15 posts - 9,181 through 9,195 (of 49,552 total)
New Born DBA (4/29/2014)
I have no skill on performance tuning whatsoever, however I tried following this link https://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/ and ran a trace.
That article points out that just looking for the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2014 at 12:10 pm
You'll never see more than 4 threads in the RUNNABLE or RUNNING states. Scheduler ID is just which scheduler the thread is associated with.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2014 at 9:07 am
????
To restore a database, right click the databases folder (object explorer), select Restore database. Select the Device radio button. Locate the backup, select which backupset in the file you want...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2014 at 8:55 am
No plans, but I have advised two clients to consider replacing SQL 2012 with SQL 2014 in their upgrade plans. Partially because, knowing these guys, they won't actually upgrade until...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2014 at 7:40 am
You never need to create a dummy database before restoring. The restore process creates the database. Creating an empty database and then restoring over it is just a waste of...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2014 at 5:14 am
All backups, regardless of their type, should go to their own individual file, preferably stamped with the date and time of the backup.
Differential backup, just like a full, is an...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2014 at 5:11 am
An .ndf will be part of a full database backup (BACKUP DATABASE ...) and will be restored as part of a full database restore (RESTORE DATABASE)
p.s. Please in future post...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2014 at 4:10 am
MAXDOP limits the number of *runnning* tasks, not the total number of tasks.
If four operators in a query all parallel and MAXDOP is 4, you can easily see 16 or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2014 at 2:41 am
karend211 34657 (4/28/2014)
I am thinking worst case scenario & want to be prepared & have a plan for all avenues.
To be honest, short of corrupted/missing OS files, I can't think...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 29, 2014 at 2:38 am
Columns cannot be present twice in an index.
It's so that when someone changes a clustered index, your carefully crafted nonclustered index doesn't suddenly become useless. I don't like side effects,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 28, 2014 at 3:03 pm
What's car rental prices like?
If it might work out easier to drive Birmingham down to Swansea then I'm OK doing that. Currently looking at that national coach site. Not...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 28, 2014 at 10:05 am
If you are creating an index to support a query and, to support that query the clustered index key is needed either as key or include column, then put it...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 28, 2014 at 9:12 am
paul.knibbs (4/28/2014)
GilaMonster (4/28/2014)
Gotta love a country where public transport actually works.
For certain values of "works"... 🙂
Exists, is safe, is reliable and gets me where I want to go.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 28, 2014 at 8:09 am
george sibbald (4/28/2014)
Would not the answer to this be 'it depends'
No.
If you're creating an index and are trying to decide between explicitly putting the clustered index key in the index...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 28, 2014 at 8:07 am
David Burrows (4/28/2014)
GilaMonster (4/28/2014)
Not yet certain if that's where I'll go, but may well be a place...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 28, 2014 at 7:48 am
Viewing 15 posts - 9,181 through 9,195 (of 49,552 total)