network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 4 years |
| seen | Jul 13 '12 at 14:59 | |
| stats | profile views | 177 |
|
Nov 7 |
answered | Optimal Disk Setup for OLTP SQL Server |
|
Nov 2 |
answered | Opening Trace in SQL Server Profiler Using Disk Space |
|
Nov 1 |
comment |
SQL Server logging stops lengthy SharePoint operation Hi Shiraz, no not easily - you can by moving tables between filegroups - documented here :sqlskills.com/BLOGS/PAUL/post/… I guess the question is whether Dan actually needs the released space? |
|
Nov 1 |
comment |
SQL Server logging stops lengthy SharePoint operation The space gained from deleting objects remains as white space within the database. This white space will be reused instead of having to grow the database file (.MDF) further. |
|
Nov 1 |
comment |
SQL Server logging stops lengthy SharePoint operation Note, all the shrink operations have bad side affects: 1) they run single-threaded so take a long time, 2) they generate a lot of transaction log growth, 3) they fragment the indexes within the DB - possibly causing poor performance. |
|
Nov 1 |
comment |
Best way to rebuild all indexes on all tables in SQL Server 2005 Oh and I use this script on a number of Production instances - so can recommend it. |
|
Nov 1 |
answered | Best way to rebuild all indexes on all tables in SQL Server 2005 |
|
Nov 1 |
comment |
Best way to rebuild all indexes on all tables in SQL Server 2005 Sqlfool's script runs against all databases by default, no need for sp_MSforeachDB. |
|
Nov 1 |
revised |
SQL Server logging stops lengthy SharePoint operation deleted 1 characters in body |
|
Oct 31 |
awarded | Tumbleweed |
|
Oct 31 |
answered | SQL Server logging stops lengthy SharePoint operation |
|
Oct 31 |
comment |
SQL Server logging stops lengthy SharePoint operation Shrinking the log file isn't bad, but shrinking data file (.MDF or .NDF) is - it causes massive fragmentation |
|
Oct 27 |
revised |
Weird TPS peaks on SQL 2005 replicated database added 111 characters in body |
|
Oct 27 |
comment |
locked out of my own SQL server Is the SQL Server services running in a dedicated service account with admin privileges? If so can you use that to authenticate? |
|
Oct 24 |
asked | Weird TPS peaks on SQL 2005 replicated database |
|
Oct 22 |
comment |
Would the database compatibility level affect performance? You should be running index/stat maintenance regularly. Here's a couple a couple of excellent custom scripts which can do this on SQL2005/2008: sqlfool.com/2009/06/index-defrag-script-v30 ola.hallengren.com/#1227266 |
|
Oct 21 |
comment |
Would the database compatibility level affect performance? Also rebuild stats. |
|
Oct 21 |
answered | SQL Environment Backup Question |
|
Oct 21 |
comment |
SQL Environment Backup Question A potential risk with this: If your full monthly backup fails to restore (for whatever reason) - all of your diffs are useless, you'd lose up to a month's worth of data. |
|
Oct 20 |
comment |
SQL Environment Backup Question Are you using the latest version of LiteSpeed with the highest level of compression? |
