Viewing 15 posts - 30,076 through 30,090 (of 49,552 total)
In order
Yes
Yes
Absolutely no idea (it's your database, you must have some idea how busy it is)
No
No
No
Once more: SQL runs checkpoints automatically. You typically do not have to do so manually.
Please,...
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
October 10, 2010 at 11:18 pm
One other thing I noticed. You said direct attached storage. What RAID level do you have on those drives?
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
October 10, 2010 at 5:35 pm
Integration services is not a free component.
You can either download the 180 day trial version of SQL, or look at buying developer edition.
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
October 10, 2010 at 5:31 pm
Derrick Smith (10/8/2010)
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
October 10, 2010 at 3:18 pm
grahamc (10/8/2010)
L,O - User DB LOG files
Log files plural? Multiple DBs I assume.
P - PageFile - I think this is quite a biggie and one that is normally forgotten about....
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
October 10, 2010 at 3:14 pm
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Why is this posted under reporting services? No...
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
October 10, 2010 at 8:56 am
Well that's my T-SQL Tuesday post done and scheduled. Took me far longer than I had planned to write.
Has anyone here, other than Wayne, written a blog post or article...
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
October 10, 2010 at 7:38 am
Table definitions and some sample data would help.
You need either some column or set of columns that are unique, or a transaction date to be able to do this.
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
October 9, 2010 at 12:38 pm
ahmed.net (10/9/2010)
Whether or not changing the order of columns in where clause can effect performance(using OR in where)?
Nope.
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
October 9, 2010 at 9:55 am
Corruption is typically an IO subsystem problem. Look in the windows event logs, SAN logs, RAID driver logs, etc for anything out of the ordinary.
You'll have to restore. This is...
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
October 9, 2010 at 9:53 am
Remove the shrink tasks completely. They are hurting your database.
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
October 9, 2010 at 3:49 am
Try this: http://www.sqlservercentral.com/articles/Indexing/68439/ (3-part series)
and these
http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/
http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/
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
October 9, 2010 at 2:14 am
Got any traceflags on? If so, which ones?
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
October 9, 2010 at 2:12 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1001678-1291-1.aspx
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
October 9, 2010 at 2:11 am
Firstly why the hell are you shrinking the databases?
Databases tend to grow as more data gets put in them. It's in their nature.
Shrinking causes massive fragmentation and will just result...
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
October 9, 2010 at 2:09 am
Viewing 15 posts - 30,076 through 30,090 (of 49,552 total)