Viewing 15 posts - 151 through 165 (of 596 total)
I too had no idea what a leaderboard was with respect to golf. So i looked it up. It seems that individuals with the same score are give...
October 23, 2007 at 8:33 am
A database that large will take quite some time to do the restore. Management Studio will show the progress but there is always an initial period required before it...
October 22, 2007 at 10:15 am
I have a BSc in Computer Science and a MBA in management. I works as A SQL Server DBA for a healthcare facility. Ongoing education is very important....
October 19, 2007 at 7:41 am
To be a DBA it is not necessary to have previously worked as a database developer but it helps. Having done at least some work in development using ...
October 18, 2007 at 8:00 am
Good point Arun. If there is some unusual event that causes the log to grow then shrinking it may be of value. However, if some daily(or weekly)...
October 12, 2007 at 1:12 pm
If the transaction log doesn't shrink and you cannot make it, do a search on 'SHrink log' on this site. There are a couple of scripts posted that I...
October 11, 2007 at 8:48 am
It doesn't seem as if this command should take 4 hours with the kind of response you describe. Are you sure its this command that getting hung up? ...
October 11, 2007 at 7:11 am
see http://www.sqlservercentral.com/articles/Administering/dumpsqlpermissions/1314/
or the following example lists all permissions that user BILL has in the current database.
EXEC sp_helprotect NULL, 'BILL'
October 10, 2007 at 12:17 pm
Does it take a really long time to do a showcontig on just one particular table (pick a small table) What about the largest table. Run...
October 10, 2007 at 10:01 am
I have removed the builtin account on my clusters and it works. The cluster account must be made sysadmin as is the account the runs SQL and SQL Agent
October 9, 2007 at 9:08 am
Check the SQL Server Logs to see if there are any relevant massages. Also check the OS Event Log. Do any scheduled jobs run at this time that...
October 9, 2007 at 8:51 am
Check out Dynamic Pivot both on this site and generally.
Here are some sample articles:
http://www.sqlservercentral.com/articles/Advanced+Querying/pivottableformicrosoftsqlserver/2434/
http://weblogs.sqlteam.com/jeffs/archive/2005/05/02/4842.aspx
It may take more than a few minutes to understand this...
October 5, 2007 at 2:40 pm
See http://vyaskn.tripod.com/sp_who3.htm for a good script that can be used to detect blocks (via EXEC sp_who_3 @run_mode = 'block' command)
Microsoft aslo has help on...
October 5, 2007 at 11:37 am
More than once I have either found the answer to a problem I was having on SSC or I have posted a question and have received thoughtful and valid responses...
October 4, 2007 at 3:00 pm
I haven't had any issue with the backup part of the maintenance plan but I have had issue with the clean up not being done. Some of my servers have multiple user...
September 12, 2007 at 7:28 am
Viewing 15 posts - 151 through 165 (of 596 total)