Viewing 15 posts - 11,701 through 11,715 (of 22,214 total)
What about building a drug name mapping table. You run through the data once, nightly, after a load, something, and map the names supplied to the drugs available into a...
October 20, 2011 at 5:17 am
When you create a database you are required to create a transaction log as part of creating the database, so I don't think you're talking about that. The SQL Server...
October 20, 2011 at 5:08 am
Sorry, I was slow getting back here. Gail's answering everything. Just out of curiosity, what is the cost threshold for parallelism on your server?
October 19, 2011 at 12:11 pm
bkubicek (10/19/2011)
Grant Fritchey (10/19/2011)
If you’re a finalist we will need to confirm...
October 19, 2011 at 7:07 am
By the way, DBA is just a term, we're talking data professionals concerned with databases. From the rules:
If you’re a finalist we will need to confirm that you work...
October 19, 2011 at 6:37 am
Ooh, right, fill factor. Where's my head. Thanks Ninja!
October 19, 2011 at 6:18 am
What are the 2nd & 3rd highest wait types. Unless you're sure that parallelism is actually a problem on your system (probably evidenced by CPU binding), this is not necessarily...
October 19, 2011 at 6:15 am
That's an odd one. What version of SSMS are you running and what version of SQL Server is the server itself? You may need to update both.
October 19, 2011 at 6:13 am
Also, you may want to assess which columns are defining the clustered index. If it's fragmenting that much, maybe you need a different cluster, possibly. Also, you need to evaluate...
October 19, 2011 at 6:11 am
Pants got to eat, same as worms.
October 18, 2011 at 1:42 pm
Evil Kraig F (10/18/2011)
SQLRNNR (10/18/2011)
Grant Fritchey (10/18/2011)
Brandie Tarvin (10/18/2011)
Ninja's_RGR'us (10/18/2011)
Brandie Tarvin (10/18/2011)
Ninja's_RGR'us (10/18/2011)
Brandie Tarvin (10/18/2011)
SQLRNNR (10/18/2011)
Must be the force - it's what I was shooting for;-)
I sense a great disturbance...
...oh,...
October 18, 2011 at 12:33 pm
Brandie Tarvin (10/18/2011)
Ninja's_RGR'us (10/18/2011)
Brandie Tarvin (10/18/2011)
Ninja's_RGR'us (10/18/2011)
Brandie Tarvin (10/18/2011)
SQLRNNR (10/18/2011)
Must be the force - it's what I was shooting for;-)
I sense a great disturbance...
...oh, wait. That was the Blackberry outage....
October 18, 2011 at 12:15 pm
Brandie Tarvin (10/18/2011)
Ninja's_RGR'us (10/18/2011)
Brandie Tarvin (10/18/2011)
SQLRNNR (10/18/2011)
Must be the force - it's what I was shooting for;-)I sense a great disturbance...
...oh, wait. That was the Blackberry outage. Nevermind.
pre-edit bad pun...
October 18, 2011 at 10:09 am
ALZDBA (10/18/2011)
Roy Ernest (10/17/2011)
Jack Corbett (10/17/2011)
SQLRNNR (10/17/2011)
Evil Kraig F (10/17/2011)
October 18, 2011 at 4:36 am
Kiara (10/17/2011)
Grant Fritchey (10/16/2011)
October 17, 2011 at 6:32 am
Viewing 15 posts - 11,701 through 11,715 (of 22,214 total)