Viewing 15 posts - 40,276 through 40,290 (of 49,552 total)
shnex (3/18/2009)
The guids in the pk are generally used for joins...so I have to change the index in a clustered one...
No. Not good. Definitely not good.
Guids are a terrible choice...
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 18, 2009 at 1:42 pm
shnex (3/18/2009)
I have a heap and a clustered index for the same object_id.
That's not possible. How are you identifying that you have a heap and a cluster for that table?
What's...
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 18, 2009 at 10:13 am
BACKUP LOG MyImportantDB WITH NO_LOGBACKUP LOG MyImportantDB WITH TRUNCATE_ONLY
DUMP TRAN MyImportantDB WITH NO_LOG
Just an additional point. All three of those were deprecated in SQL 2005 and removed in SQL 2008....
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 18, 2009 at 10:02 am
shnex (3/18/2009)
let me ask in this way: if I query sys.dm_db_index_physical_stats and get the same object_id for a heap and an index is an abnormal situation?
No.
The object_id is 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 18, 2009 at 9:50 am
tk.taunton1 (3/18/2009)
I quickly took a look at my maintenance plan for T-Log backup and FULL backup, and SHRINK DATABASE task
Ack! Shrink? Why?
Shrinking causes massive fragmentation and will just...
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 18, 2009 at 9:42 am
Susan Laing (3/18/2009)
Why also would it let me detach a database which is not possible to restore?
SQL 2008 doesn't allow it. That the earlier versions did was an omission. Any...
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 18, 2009 at 9:30 am
GNUZEN (3/18/2009)
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 18, 2009 at 9:27 am
shnex (3/18/2009)
if I drop and create the existing index on that table, the heap should disapear?
I'm not sure we're exactly clear on the definition of a heap.
A heap is a...
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 18, 2009 at 9:09 am
Pleasure
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 18, 2009 at 9:07 am
tk.taunton1 (3/18/2009)
As far as I understand these T-Log backups 'truncate' the T-Log automatically.
Yup. They back up the inactive log records, write them to the log backup file...
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 18, 2009 at 9:06 am
krypto69 (3/18/2009)
Guess I was just wondering if putting it as the very first line will always work, on all types of statements?
Putting it on the first line is your only...
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 18, 2009 at 9:01 am
I think the string and comment handling needs a little more work
http://www.sqlservercentral.com/Forums/FindPost678555.aspx
--here's a single quote within a comment
select 'String 1', 012
select 'String 3', 789 -- that's not what I wanted...
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 18, 2009 at 8:55 am
Steve Jones - Editor (3/17/2009)
New code formatting has been released on SSC.
Ooooohhhh..... Nice!
Jack Corbett (3/17/2009)
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 18, 2009 at 8:30 am
mrizabid (3/18/2009)
Me facing this problem when i m executing particular critearea like date between '2007-08-01' and '2007-08-31'
What does that have to do with setting the recovery interval?
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 18, 2009 at 8:30 am
krypto69 (3/18/2009)
I have been tasked with making sure a group of stored procedures all have the transaction isolation level to 'READ UNCOMMITED'
For what reason? Does the person who asked know...
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 18, 2009 at 8:25 am
Viewing 15 posts - 40,276 through 40,290 (of 49,552 total)