Viewing 15 posts - 6,166 through 6,180 (of 49,571 total)
Jeff Moden (4/14/2015)
April 15, 2015 at 5:26 am
At that granularity, not all that much. You need to have much more granular data to be able to see trends and behaviors. I prefer to have no more than...
April 15, 2015 at 5:24 am
When you create the partitioning, data will be moved to the correct partition.
That said, it's not likely to help your performance problems, partitioning is for maintenance and fast data loads/deletes
April 15, 2015 at 4:31 am
Then you're either going to have to accept that the delete will have more severe impact (because it's not batched) or do something complex like insert the rows into another...
April 15, 2015 at 3:24 am
Naveen J V (4/15/2015)
since table is very large, I cannot remove batch delete process.
But by adding a transaction you'll have that effect. Deletes are done in batches to keep the...
April 15, 2015 at 3:09 am
What's wrong is that the primary key of the table you're referencing is not on the column that you're using in the foreign key. A foreign key requires that the...
April 15, 2015 at 3:06 am
You have a corrupt database.
When did you last run a successful database consistency check?
What backups do you have?
April 15, 2015 at 2:57 am
If you wrap that in a transaction, then you're removing the point of running batched deletes in a loop, you may as well remove the while and the top if...
April 15, 2015 at 2:48 am
PHYData DBA (4/14/2015)
Then I would use SELECT count(*), GetDate() from <table name> to be certain.
Counting every row in the table just to see whether the table has a row or...
April 15, 2015 at 2:41 am
Robert Frasca (4/14/2015)
columnY gets updated.What is the impact of the update on the index?
The index gets updated.
Yes, it can cause page splits if ColumnY is updated to something...
April 15, 2015 at 2:38 am
MotivateMan1394 (4/14/2015)
"The dbcc run successfull or not "And where Do I read the reaport ?
In the job history. When it's successful that's all the report there is.
April 15, 2015 at 2:32 am
MotivateMan1394 (4/14/2015)
Can I use this command to check my databases every night. (in a job)
Absolutely, yes. Every night if you can, less often if you don't have the time every...
April 14, 2015 at 5:24 am
Grant Fritchey (4/14/2015)
You could try searching sys.dm_exec_query_stats in combination with sys.dm_exec_sql_text to find DELETE/TRUNCATE statements.
Truncate doesn't get cached iirc, because it's a DDL statement
April 14, 2015 at 4:57 am
Honestly, it depends on your requirements.
If an error in any of the 10 procedures means that the entire processing should be aborted, then error handling in the caller. If an...
April 14, 2015 at 3:51 am
Unless you had a trigger on the table or some form of auditing in place, it is extremely unlikely that you will be able to tell after the fact who...
April 14, 2015 at 2:45 am
Viewing 15 posts - 6,166 through 6,180 (of 49,571 total)