Viewing 15 posts - 16 through 30 (of 44 total)
codebyo (10/5/2011)
mendesm (10/5/2011)
These days, the...
October 5, 2011 at 8:10 pm
sonny_bhalla (7/4/2011)
Dream of becoming a DBA is challenging. I am figuring this out these days. I got my MCITP/MCTS in SQL 2008, now what? Companies these days are...
October 5, 2011 at 7:30 pm
I'm the guy who say's "NO!" the most at work and probably the least liked, but I'm the most popular guy when it comes to getting people from having to...
October 5, 2011 at 7:05 pm
They as a question, I then try to understand what the hell they are talking about by asking them a bunch of other questions. If I end up understanding...
October 5, 2011 at 6:57 pm
There's a difference between dropping a table (removing them completely from the database) and deleting their contents. Which one are you trying to do?
October 5, 2011 at 6:39 pm
You want to uninstall SQL Server. Pay attention to the prompts as you'll tell it what you want to uninstall (in this case just SSIS and leave the rest...
October 5, 2011 at 6:25 pm
I do some digging around and when needed I'll run the profiler. When all that fails, I send my client to ask the questions to those who designed the...
October 5, 2011 at 6:23 pm
run the same query, in MYDB, but join sys.dm_io_virtual_file_stats ((DB_ID(N'MYDB'), NULL) to sys.database_files on file_id
October 5, 2011 at 6:05 pm
GilaMonster (10/5/2011)
isuckatsql (10/5/2011)
I will be using:Raid1 - Program Files (2 HD)
Raid10 - Data files (10 HD)
Raid1 - Log Files (2 HD)
Raid0 - TempDB files 2(HD)
Sure you want to use that?...
October 5, 2011 at 5:33 pm
... and see if they don't choke you Vader-style.
I'm going to have to use that in the near future 😀
October 5, 2011 at 5:27 pm
jared-709193 (10/5/2011)
mendesm (10/5/2011)
October 5, 2011 at 5:25 pm
Evil Kraig F (10/5/2011)
opc.three (10/5/2011)
In particular, if you're running SQL Express (thus no SQL Agent) and want to do a BCP/Bulk Insert and then archive the file you've done it...
October 5, 2011 at 5:15 pm
jared-709193 (10/5/2011)
Umm... Why not? 🙂Jared
The instance running on these boxes never actually get to consume memory anywhere near the amount available to them. They're also set up so that...
October 5, 2011 at 3:11 pm
The OS is on C:. These boxes have no swap/page file
October 5, 2011 at 2:16 pm
Mine or his? =) We have no page file on these SQL boxes.
October 5, 2011 at 2:13 pm
Viewing 15 posts - 16 through 30 (of 44 total)