Viewing 15 posts - 31,951 through 31,965 (of 49,552 total)
sysindexes is deprecated, included for backward compatibility with SQL 2000 and should not be used in new development.
To find what filegroup a table or is on, query sys.partitions and...
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
July 6, 2010 at 1:30 pm
You cannot change the structure of a database during a restore. If a DB had 4 filegroups when it was backed up, it will have 4 filegroups when restored.
Restore 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
July 6, 2010 at 12:52 pm
DECLARE @Basic numeric(5,2), @Interval numeric(5,2)
SET @Basic = 4
SET @Interval = @Basic * 21 / 30
SELECT Round(@Interval,0)
The @Basic*21/30 was done as integer maths (as all operands were ints), hence decimals...
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
July 6, 2010 at 12:28 pm
You need a trigger on every table. You can write up some code based on sys.tables to create the triggers, but there will have to be one for each table...
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
July 6, 2010 at 12:05 pm
http://en.wikipedia.org/wiki/Combinatorics
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
July 6, 2010 at 12:04 pm
jcrawf02 (7/6/2010)
will you guys cut this crap out? If I wanted to LEARN, I'd go somewhere else...:-D:hehe:
RotFL 😀
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
July 6, 2010 at 11:42 am
Paul Randal (7/6/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
July 6, 2010 at 11:22 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic948031-391-1.aspx
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
July 6, 2010 at 11:10 am
I would strongly suggest that you restore from backup, apply all your log backups. Is usually best option for recovering from corruption.
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
July 6, 2010 at 10:55 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic948031-391-1.aspx
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
July 6, 2010 at 10:54 am
If there are multiple filegroups, you can fine out which one the table is in by querying sys.partitions and (I think) sys.data_spaces. If you're talking about multiple files in one...
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
July 6, 2010 at 10:51 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic948031-391-1.aspx
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
July 6, 2010 at 10:47 am
The default trace cannot be modified. Create your own trace script (export from Profiler if you like) and run that for the periods that you want.
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
July 6, 2010 at 10:33 am
Snapshot and merge none. Transactional the log reader reads the changes from the transaction log and writes them through to the distributor
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
July 6, 2010 at 6:53 am
All modifications are always logged regardless of recovery model. In bulk logged, some operations can be minimally logged, which means less log impact (log growth), but larger log backups and...
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
July 6, 2010 at 5:52 am
Viewing 15 posts - 31,951 through 31,965 (of 49,552 total)