Viewing 15 posts - 43,621 through 43,635 (of 49,571 total)
Before you worry about indexing or anything else, I would strongly recommend that you consider normalising that table. You have massive amounts of redundant data and several sets of completely...
October 23, 2008 at 12:30 pm
mohinidba (10/22/2008)
there is any command in sql to shut down the database.shutdown means take offline.only db_owner has that rights.
Why? What are you trying to do?
October 23, 2008 at 10:26 am
watson_mike (10/23/2008)
October 23, 2008 at 10:23 am
For that particular query, an index on [order date] INCLUDE [system qty] will help. If you're after more general recommendations, post the table structure, the index definitions and the most...
October 23, 2008 at 10:22 am
Paula (10/23/2008)
When that happens it runs sp_reset_connection, which then turns auto update statistics off and back on again. It is apparently common with .NET Apps.
Reset connection is...
October 23, 2008 at 8:50 am
Some process or job is changing the database setting and enabling and disabling the feature. SQL won't by itself, change a database's settings.
You can run profiler for a while to...
October 23, 2008 at 8:24 am
It is on it's way and it is almost done. Can't say more, can't give a date.
October 23, 2008 at 8:01 am
Roust_m (10/23/2008)
I was under impression that every single DBCC command is now deprecated.
Some of them (showcontig, index defrag, etc) are deprecated, however there are a large number still...
October 23, 2008 at 7:58 am
Leo (10/22/2008)
According from your suggestion I have now change my some databases to SIMPLE Mode. I hope I don't need to worry about the log space anymore.
Nope. I suggested...
October 22, 2008 at 3:15 pm
It could be statistics, it could be poor indexes, it could be poorly written queries, it could be inadequate hardware. At the moment it looks like high CPU usage. Run...
October 22, 2008 at 12:49 pm
gavinparnaby (10/22/2008)
@Lynn
. You're essentially correct with your synopsis of the situation. Unfortunately my team consists of 2 + me while there are 20+ users each with multiple databases. I'm well...October 22, 2008 at 12:38 pm
Eugene (10/22/2008)
You need set 1204 in combination with the 3605 flag:
The output of the flag will be sent to the SQL Server error log whenever SQL Server encounters...
October 22, 2008 at 12:20 pm
victor_bosc (10/22/2008)
I am shrinking the files, because I think that the log’s size is increasing the backup times. What do you think?
Not likely. Backups are only concerned with the contents...
October 22, 2008 at 12:06 pm
victor_bosc (10/22/2008)
Optimization job, which rebuild indexes and shrink database files
Why?
I generally refer to that job setup as a complete waste of time. The rebuild indexes takes a lot of CPU,...
October 22, 2008 at 10:17 am
shavais (10/22/2008)
So I guess it comes with the client tools? Can I download just the client tools from somewhere?Thanks again for your help!
No, the client tools are...
October 22, 2008 at 10:09 am
Viewing 15 posts - 43,621 through 43,635 (of 49,571 total)