Viewing 15 posts - 27,991 through 28,005 (of 39,804 total)
Make the SQL Service account the owner of the folder? might be inheriting permissions from above for the files.
July 2, 2008 at 1:45 pm
It's hard to QA the questions sometimes. It requires a huge amount of knowledge of SQL Server and you'd have to spend an inordinate amount of time setting up scenarios...
July 2, 2008 at 1:45 pm
Start with the 70-431 exam. It's for the basic certification and it's a general one.
Pick up a book on the exam, and go through it, working through the exercises. You...
July 2, 2008 at 10:34 am
The questions has been corrected, and typos do slip through.
The idea isn't to trick you, but help you learn something about SQL Server. There are multiple ways to move...
July 2, 2008 at 10:28 am
There are no databases that have Autoclose set?
Very strange. Have you tried Profiling around that time, looking for something strange?
Can you DBCC INPUTBUFFER the SPID when that occurs?
July 2, 2008 at 10:07 am
This is a very open ended question.
you might start here: http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/indexcreationguidelines/1389/
Clustered indexes (only 1 per table) are good for range queries.
Nonclustered are good for seeks to specific rows.
You generally...
July 2, 2008 at 9:45 am
What do you mean reduce duplication?
Litespeed (and Red Gage/Hyperbac) perform compression, which involves some tokens and pattern replacement, just like ZIP files.
Litespeed, and the other vendors, provide utilitis to uncompress...
July 2, 2008 at 9:42 am
The MDF specification isn't available. This is meant to be read by the SQL Server service only. To extract tables, you'd connect to the SQL Server service and select them...
July 2, 2008 at 9:30 am
There are a number of DMVs that can get you server information. You can start here: http://www.codeproject.com/KB/database/Dynamic_Management_Views.aspx
July 1, 2008 at 9:56 pm
Which new table? Replication is by publication, so if you create a new table, you need a new replication publication.
July 1, 2008 at 3:56 pm
Usually you'll find if there's a network glitch, the backup will fail. I almost never run the backup across the network. run it locally and copy it.
July 1, 2008 at 3:55 pm
nope, backup, detach, uninstall, reinstall.
sp_help_revlogin to save logins.
July 1, 2008 at 11:16 am
I don't think this is allowed directly. Maybe with a UDF?
July 1, 2008 at 11:15 am
I'd think that something must have changed. If not, the DBCC shouldn't have doubled.
One thing to note, that checkdb includes a checkcatalog and checktable. Paul Randal has a series on...
July 1, 2008 at 11:14 am
Check the snapshot.sys.users to see what's mapped there and see if you have unmatched SIDs.
Or run sp_change_users_login with the reporting option.
July 1, 2008 at 11:11 am
Viewing 15 posts - 27,991 through 28,005 (of 39,804 total)