Viewing 15 posts - 30,061 through 30,075 (of 49,552 total)
If appdate_dte is a datetime column, the date format is irrelevant. You'll be comparing a date with a date, no formatting applies.
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
October 11, 2010 at 5:02 am
The system views that you need are sys.database_principals and sys.database_permissions.
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
October 11, 2010 at 5:01 am
Generally it's not that good an idea to back up over the network. It's far slower than disks and a network glitch will cause the backup to fail.
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
October 11, 2010 at 4:02 am
Generally the only time you want to shrink a log to 0 is if you're trying to clean up the VLFs. Shrink to 0 then immediately grow it to 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
October 11, 2010 at 4:01 am
winston Smith (10/11/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
October 11, 2010 at 3:36 am
Gianluca Sartori (10/11/2010)
If you still want to shrink it, you can run DBCC SHRINKFILE('yourLDFfileNameGoesHere', 0). This will shrink the LDF file at its minimum possible size.
Generally doing this 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
October 11, 2010 at 3:29 am
Take the database offline, bring it back online. It'll wipe those DMVs and a whole lot more (including data cache and procedure cache). Not recommended on a busy production server.
Why...
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
October 11, 2010 at 3:25 am
You're treating the symptoms, not the cause.
Don't focus on shrinking the log, focus on finding out why it's growing and resolving whatever that is. Start by checking the size of...
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
October 11, 2010 at 3:21 am
Backup to a local drive, once completed copy the file whereever you want it.
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
October 11, 2010 at 2:05 am
Ow, ow, ow. Why on earth are you doing this to your database?
Setting to simple recovery breaks the log chain. You will not be able to take a log backup...
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
October 11, 2010 at 2:03 am
Depends.
if SQL is still running and the DB is still listed as a database on that server and the log file is undamaged you can take a tail log backup....
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
October 11, 2010 at 1:50 am
p.p.s. The value listed in Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE is in bytes. So that's 512 kB that it needs to allocate. Far cry from 500 GB.
This may be worth...
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
October 10, 2010 at 11:37 pm
An indexed view is materialised and stored as if it were a 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
October 10, 2010 at 11:27 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1001923-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
October 10, 2010 at 11:24 pm
Oh my, that is a seriously bad idea.
-g defines the mem-to-leave in MB, the portion of memory that SQL can use OUTSIDE the buffer pool. You're asking for the mem-to-leave...
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
October 10, 2010 at 11:23 pm
Viewing 15 posts - 30,061 through 30,075 (of 49,552 total)