Viewing 15 posts - 40,291 through 40,305 (of 49,571 total)
dallas13 (3/18/2009)
i have created a policy on sql 2008 now i need to apply thatpolicy on sql 2005 server. is that possible?
No. Policies are a 2008 feature.
You can evaluate...
March 18, 2009 at 2:12 pm
JMSM (3/18/2009)
March 18, 2009 at 2:03 pm
jfoster (3/18/2009)
For those using pre-SQL 2008 servers, this would still be in the toolbox if needed and should be used with their scope in mind.
I'd say no, even pre-2008, either...
March 18, 2009 at 1:51 pm
Matt (3/18/2009)
I've found the perfect tool to use on the server to help me out, it's called a sledge hammer
😀 There's a reason I have a hammer in my computer...
March 18, 2009 at 1:46 pm
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...
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...
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....
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...
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...
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...
March 18, 2009 at 9:30 am
GNUZEN (3/18/2009)
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...
March 18, 2009 at 9:09 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...
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...
March 18, 2009 at 9:01 am
Viewing 15 posts - 40,291 through 40,305 (of 49,571 total)