Viewing 15 posts - 151 through 165 (of 335 total)
Like you mentioned, create an alert:
Location in management studio: SQL SERVER->SQL Server Agent->Alerts
* GENERAL TAB*
type : SQL server performance condition alert
object: SQL Server: General statistics
counter: processes blocked
alert if rises above...
October 14, 2008 at 4:52 am
As been told, the errorlog is no database table. Query the registry (use xp_regread) for the location of the errorlog.
You can also use this construction to copy the errorlogfile into...
October 14, 2008 at 4:40 am
... do I need to rebuild the index after truncating the table to get the index size under control?...
If you truncate the table, SQL marks the table as empty/reusable. All...
October 14, 2008 at 4:35 am
Start reading Books Online ("BOL" is the abbreviation you'll see on Forums) and search for the DBCC command, especially CHECKDB
October 13, 2008 at 6:02 am
Yeah, I know that discussion.
Make sure you know the benefits of asynchronously update stats before calling them.
Good luck
October 9, 2008 at 8:45 am
What? Not enabling auto_create_stats is asking for a performance showstopper. (I don't think I'll have to tell you why)
Determine the overhead and time you'll have to spend on determine which...
October 9, 2008 at 8:03 am
Here comes the Microsoft answer: "Upgrade to MSSQL 2008, start using the MERGE statement" :D:D
October 9, 2008 at 4:43 am
Hey, another W van Dijk! 🙂
Post this question in the T-SQL forum
October 9, 2008 at 4:37 am
Had the same issue, try this script for fixing collation in your tables:
------------------------------------------------------------
-- LM_ChangeCollation - Change collation in all tables
-- made by Luis Monteiro - ljmonteiro@eurociber.pt
-- modified by wilfred...
October 9, 2008 at 2:12 am
If you run sp_updatestats SQL tells you which statistics were updated. The algoritm SQL uses is documented on the internet, maybe somebody can provide the link?
October 9, 2008 at 2:05 am
Also check:
- SQL version (equal ?)
- physical drive design, location of datafiles/logfiles
- statistics
- index fragmentation
October 9, 2008 at 2:01 am
You're mixing snapshot backups (performed by NetApp Snapmanager) with SQL database snapshots.
This is a totally different concept.
When we are talking about snapshots, what do you mean? When your system administrator...
October 9, 2008 at 1:39 am
To move a database from 2000 to 2005 you CANNOT detach/attach. You must backup/restore.
This in not true for user databases (read the article, it's true for system databases). Upgrading to...
October 8, 2008 at 1:10 pm
So ur actually saying SQL does not recreate these indexes on restore
Correct, indexes are not recreated after a restore. The indexpages are part of the backup and they are...
October 7, 2008 at 8:06 am
Viewing 15 posts - 151 through 165 (of 335 total)