Viewing 15 posts - 11,026 through 11,040 (of 49,552 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...
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
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...
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
November 7, 2013 at 1:14 pm
ID BIGINT IDENTITY NOT NULL
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
November 7, 2013 at 1:07 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...
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
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...
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
November 7, 2013 at 6:20 am
Edit: log file, not log backups.
Without the error, guessing. Does the drive and path exist?
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
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...
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
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...
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
November 7, 2013 at 3:45 am
Not without a lot more information. Need table definitions, index definitions, queries, execution plans.
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
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.
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
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.
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
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...
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
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,...
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
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...
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
November 6, 2013 at 10:03 pm
Carl B. (11/6/2013)
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
November 6, 2013 at 2:12 pm
Viewing 15 posts - 11,026 through 11,040 (of 49,552 total)