Viewing 15 posts - 631 through 645 (of 1,319 total)
Personally, I never backup the data folder. Unless you shutdown the SQL server, the files are in use. As stated by David, there are some applications that allow you to...
May 22, 2009 at 8:54 am
Personally, I wouldn't setup any relationships between the data (FK constraints) as this could affect the data load and it's simply a reporting database. Besides, those types of relationships are...
May 22, 2009 at 8:28 am
You can use sp_who or sp_who2 to determine the thread and then issue kill spid. I'd be hesitant because if the thread does have an open transaction, the data will...
May 21, 2009 at 6:21 am
Roy Ernest (5/20/2009)
Got two kids... 😛
Face it Roy, you're already insane but are too insane to realize it! 😀
May 20, 2009 at 2:44 pm
If you can log into the physical server, open task manager to gauge what is consuming the resources. If it's SQL and you cannot get in, check the server event...
May 20, 2009 at 1:11 pm
Roy Ernest (5/20/2009)
May 20, 2009 at 10:26 am
Lynn Pettis (5/20/2009)
Tom Brown (5/20/2009)
Lynn Pettis (5/20/2009)
Roy Ernest (5/20/2009)
May 20, 2009 at 10:00 am
Alvin Ramard (5/20/2009)
tosscrosby (5/20/2009)
Lynn Pettis (5/20/2009)
May 20, 2009 at 9:52 am
Lynn Pettis (5/20/2009)
You know what? I think some of us (me included) really need a vacation in some far off exotic locale. Too bad I can't afford one...
We...
May 20, 2009 at 9:35 am
Lynn Pettis (5/20/2009)
Roy Ernest (5/20/2009)
Is the Window washer player around in T-SQL section? I just want to take a peek... 😀If you really must, he's here.
Holy smokes! Some people are...
May 20, 2009 at 9:09 am
Not sure about the third-party tools but thought I'd chime in. I use the native-OS defragmenter. Usually about once a year, maybe a little longer than that, on the entire...
May 20, 2009 at 8:56 am
This is what I do. It all depends on the amount of data loss that your users can endure - all depends on them and your application.
1) Full backup of...
May 20, 2009 at 7:57 am
achleshsoni (5/20/2009)
2009-05-20 01:22:20.300,Logon,Login failed for user 'sa' because the account is currently locked out. The system administrator...
May 20, 2009 at 7:44 am
ip2host (5/20/2009)
I didnt correctly express myself.I truncated trans logs after full backup each base and trans log.
I had to coz it reached 30gb.
After you truncate the log, you MUST do...
May 20, 2009 at 7:31 am
If this is coming via an application, never use sa. Unless your code is somehow encrypted, your sa password is then floating around embedded in code and easily obtained by...
May 20, 2009 at 7:12 am
Viewing 15 posts - 631 through 645 (of 1,319 total)