Viewing 15 posts - 11,026 through 11,040 (of 49,566 total)
Why are gaps a concern?
They're normal with identities (on all data types), and unless you're using it for something that absolutely may not legally have gaps (some industry's invoice...
November 7, 2013 at 10:08 pm
blasto_max (11/7/2013)
I want sql server to create a number and put it in ID when i insert a row into the table. How do I do it ?
Exactly as I...
November 7, 2013 at 1:14 pm
Carl B. (11/7/2013)
I mean table that contains dropped column(s) and/or table that contains modified column(s) (e.g. to increase its capacity).
DDL triggers to log schema changes or record and compare the...
November 7, 2013 at 6:23 am
IF (@User_RefID IS NULL)
WITH cte1 AS (SELECT ..[...].)
INSERT INTO .....
ELSE
WITH cte2 AS (SELECT ..[...].)
INSERT INTO .....
Watch out for performance from multistatement...
November 7, 2013 at 6:20 am
Edit: log file, not log backups.
Without the error, guessing. Does the drive and path exist?
November 7, 2013 at 5:06 am
Grant Fritchey (11/7/2013)
GilaMonster (11/6/2013)
Restoring or recovering?A DB will go restoring if someone runs BACKUP LOG ... WITH NORECOVERY ....
In what might be an epic role reversal, don't you mean RESTORE...
November 7, 2013 at 4:16 am
Defaults cannot reference column names. Per BoL:
Only a constant value, such as a character string; a scalar function (either a system, user-defined, or CLR function); or NULL can be used...
November 7, 2013 at 3:45 am
Not without a lot more information. Need table definitions, index definitions, queries, execution plans.
November 7, 2013 at 1:29 am
Old style outer join, deprecated since SQL 2005 and not allowed at all in SQL 2012. You'll need to replace them with the appropriate LEFT OUTER/RIGHT OUTER join.
November 7, 2013 at 1:18 am
Right click plan -> save as. Please don't take a screenshot, pictures of the plan are near-useless.
November 7, 2013 at 1:07 am
chandan_jha18 (11/7/2013)
GilaMonster (11/6/2013)
Next time don't restart SQL while there's a large transaction rolling back.One question here, don't you think the T-log file will keep growing even during the rollback?
No. Not...
November 7, 2013 at 12:43 am
Even with sort in tempdb, there will still be free space left from where the index used to be. How much depends on the order that the rebuilds are done,...
November 6, 2013 at 10:05 pm
Then check jobs, maintenance plans, make sure you don't have something trying to do a tail-log backup (backup with norecovery) and that no one restored the wrong DB (error log...
November 6, 2013 at 10:03 pm
Carl B. (11/6/2013)
November 6, 2013 at 2:12 pm
Viewing 15 posts - 11,026 through 11,040 (of 49,566 total)