Viewing 15 posts - 16,216 through 16,230 (of 49,552 total)
sysindexes and syscolumns are deprecated, should not be used any longer, will be removed from a future version of SQL Server. The replacements are sys.indexes and sys.columns.
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, 2012 at 1:29 am
If you have 16 GB of memory, you do not want the /3GB switch enabled, it can be harmful. I suggest you remove that switch. You just need the /PAE...
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, 2012 at 1:05 am
Evil Kraig F (10/9/2012)
YarHad (10/9/2012)
GilaMonster (10/9/2012)
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, 2012 at 6:40 pm
Not into the SQL Server error log (text file).
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, 2012 at 5:28 pm
You cannot restore down-version ever. It's not about standard edition and enterprise, it's because you're trying to restore a 2008 R2 DB onto SQL 2008.
Script objects, export data, recreate DB...
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, 2012 at 8:36 am
It's only valid when you have a row-limiting TOP. So in you want the view to return the 10 most recent rows, then the view gets a TOP 10 and...
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, 2012 at 8:30 am
Index rebuilds don't get written into the SQL Server error log. You could add a piece to your maintenance tasks to log that a rebuild was done if you like,...
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, 2012 at 8:25 am
What do you mean by 'activity log'?
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, 2012 at 7:52 am
Is the PAE switch present in boot.ini? (or is it a 64-bit OS?)
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, 2012 at 5:56 am
Setting AWE on requires a service restart to take effect.
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, 2012 at 5:25 am
Ok, let me rephrase that.
Don't use Profiler GUI against a production server. It is known to be cause issues (and that's all the way from SQL 2000 or earlier). For...
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, 2012 at 3:38 am
Please don't post multiple threads for the same question. I answered that question for you yesterday: http://www.sqlservercentral.com/Forums/Topic1369595-391-1.aspx
The way you limit memory usage in SQL is by setting max server memory,...
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 8, 2012 at 5:29 pm
Sure. The catalog views involved are sys.indexes, sys.index_columns and sys.columns (and maybe sys.tables)
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 8, 2012 at 5:10 pm
No advantages. It doesn't allow more IO threads (all threads in SQL can issue IOs to any file), it doesn't spread out IO load. As long as you're talking just...
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 8, 2012 at 4:36 pm
For recoverability, definitely. For performance, maybe. What's the IOPS for the array? What's the required IOPS for the app?
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 8, 2012 at 4:04 pm
Viewing 15 posts - 16,216 through 16,230 (of 49,552 total)