Viewing 15 posts - 33,241 through 33,255 (of 49,552 total)
I'd argue that in general
"Be familiar with the advantages and disadvantages of table variables and temp tables and use whichever is appropriate to the situation"
March 31, 2010 at 10:22 am
Ok, two questions...
1) Why, if the minimum repair level is repair_allow_data_loss, are you requesting that repair_rebuild be run? If repair_rebuild would fix it, it would be listed as the minimum...
March 31, 2010 at 10:18 am
That's not the complete output. There should be 2 or 3 more lines at the end saying how many errors checkDB found in the entire database and a repair level...
March 31, 2010 at 10:00 am
Alex V (3/31/2010)
March 31, 2010 at 9:55 am
m.John (3/31/2010)
March 31, 2010 at 9:43 am
mjarsaniya (3/31/2010)
not a one update query ....there are 5 million update queries are fired against this table.
Why are you doing 5 million updates one at a time?
March 31, 2010 at 9:42 am
Paul White NZ (3/31/2010)
GilaMonster (3/31/2010)
Except that you cannot insert into a CTE.
Someone's going to post this...may as well be me 🙂
DECLARE @T
TABLE (A INTEGER NOT NULL);
WITH ...
March 31, 2010 at 9:40 am
Paul White NZ (3/31/2010)
GilaMonster (3/31/2010)
Paul White NZ (3/31/2010)
He will still need to run EXEC sys.sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0, @time = 0, @reset = 1;
If...
March 31, 2010 at 9:38 am
An index seek is like using the telephone directory to go straight to "Mr M Brown", because it's ordered by surname. A clustered index scan is like reading the entire...
March 31, 2010 at 9:33 am
Paul White NZ (3/31/2010)
He will still need to run EXEC sys.sp_repldone @xactid = NULL, @xact_segno = NULL, @numtrans = 0, @time = 0, @reset = 1;
If this is one of...
March 31, 2010 at 9:29 am
Alex V (3/31/2010)
If I understand it right, by default my DB should be set for active transactions (?), but it is set for replication.
Nope. There are various reasons why log...
March 31, 2010 at 9:24 am
Paul White NZ (3/31/2010)
If all you want to do is to get rid of the logs, the fastest way is to use the CREATE DATABASE...FOR ATTACH_REBUILD_LOG statement.
Yes (providing the database...
March 31, 2010 at 9:21 am
keepintouch2b (3/31/2010)
create #temp (definiton)
insert into #temp
Exec smallerStoreProc
but the maintenance of #temp definition is a hassle if their...
March 31, 2010 at 9:12 am
diva.mayas (3/31/2010)
i need very basic, bcoz i am neebee to sql server job
If you're a complete beginner, you should not be worrying about SQL's internals and architecture. That's advanced stuff....
March 31, 2010 at 9:11 am
The 'severe error' is because the shrink hit the corruption and resulted in a severity 24 error. That terminated the connection resulting in the error.
Post the full output of the...
March 31, 2010 at 9:05 am
Viewing 15 posts - 33,241 through 33,255 (of 49,552 total)