Viewing 15 posts - 15,211 through 15,225 (of 49,552 total)
ganeshkumar005 (12/17/2012)
December 17, 2012 at 1:51 am
SQL backups are at a database level, so to backup an instance you need to take database backups of all databases on that instance (don't forget the system DBs)
December 17, 2012 at 1:28 am
If you retain your backups for a week or more, running CheckDB just on weekends is fine. Just be sure that you retain backups (full and log) long enough that...
December 17, 2012 at 1:25 am
Could you be more specific please?
If you mean something like this:
UPDATE Table SET SomeColumn = SomeValue WHERE SomeID between 1 and 10 -- updates 10 rows
then there's no temp table...
December 17, 2012 at 1:01 am
Were the TempDB files where they should be? Or did SQL have to create them?
December 17, 2012 at 12:58 am
Firstly, stop using the DBCC commands, they're deprecated, included only for backward compatibility with SQL Server 2000 and should not be used in new development. The replacements are ALTER INDEX...
December 17, 2012 at 12:56 am
shindle 17293 (12/16/2012)
December 17, 2012 at 12:44 am
ganeshmuthuvelu (12/16/2012)
Can anyone confirm that SQL Server 2008 R2 provides no way to find these out?
The missing index information should be in the execution plan.
Even with normal tables, you...
December 16, 2012 at 10:35 am
Get the user to run then and send you the execution plans. Analyse and see if the index suggestion in there (if any) is sensible. Otherwise analyse the plan and...
December 16, 2012 at 9:55 am
Josh Ashwood (12/16/2012)
Indeed, I must confess that I have committed the following sins according to Celko :-- Written more than three cursors in my lifetime
Check
- Used UPDATE...FROM more than once
Check
-...
December 16, 2012 at 6:49 am
mah_j (12/16/2012)
You mean besides that, I should check other options like indexing ,memory management,.....?
I mean that if you want to performance tune your query, then performance tune your query. Don't...
December 16, 2012 at 6:06 am
mah_j (12/16/2012)
I created partition over [TransDate] and all the indexes ON DB_PartitionScheme ([TransDate]),but the logical reads of this table and cpu time increase in test db.
Not surprising.
I don't know why...
December 16, 2012 at 3:24 am
Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
I have changed the DB to FULL recovery mode temporarily untill this log space is released back to the disk
Waste of time.
In simple recovery model, the...
December 16, 2012 at 3:22 am
Abdul Rahman (12/14/2012)
But after interpreting the output and discussing with the developers, they want to start with adding with(Nolock) to all the queries, detected by -T1222.
Won't help. Look at the...
December 15, 2012 at 12:59 am
Viewing 15 posts - 15,211 through 15,225 (of 49,552 total)