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"
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 31, 2010 at 10:00 am
Alex V (3/31/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 31, 2010 at 9:55 am
m.John (3/31/2010)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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 ...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 31, 2010 at 9:05 am
Viewing 15 posts - 33,241 through 33,255 (of 49,552 total)