Sorry for the double post - I accidentally posted in the SQL 2000 forum.[:$] We're implementing a RAID 10 array for the data portion of a VLDB,...
We're implementing a RAID 10 array for the data portion of a VLDB, which is mainly used for random reads. Is there an optimal segment size I should...
As a DBA I don't really like the idea of having to create a new filegroup each time a new user comes on board. However, if you horizontally...
Just to pitch in with my thoughts.... I'd have to agree with Frank on this. It would be madness to go with one user per db. Aside from the SQL...
Cursors allow you to step through resultsets row by row so that you can interact with each returned row independantly of the others. Cursors offer...
It looks like I was along the right lines when I suggested we should be testing from a remote application. Just spotted this note at the bottom of...
Dave, This is interesting. Firstly, adding a user to the db_owner role doesn't make that user a dbo user. dbo users are special users that are only...
The procedure cache is used to store execution plans from SQL statements. This includes ad-hoc SQL statements as well as executions of stored...
Hi. You need to drop the primary key constraint, and use the MOVE TO option. Once that has finished you have to rebuild the primary key...
I've found the same problem - it's frustrating and I couldn't find an answer either. In the end I gave up and went back to doing things like I did in...
Thanks for the reply. That won't quite work because the 1st day of the month could potentially also be the 1st day of the week. But your suggestion...
Hi, Hoping someone can help me here with creating a subscription that contains dynamic parameter values. I've got a report that has two parameters...
I did think about drop cleanbuffers but it's not that. Not that is was likely that a user would be running it. Could potentially be a table scan I...
I've got some issues with page life expectancy (PLE) on a server I've been monitoring for a while. Hoping that someone might have some insight into...
What's the issue with tempdb and why do you need to shrink it? Karl Grambow www.sqldbcontrol.com
You should not shrink the database, doing so introduces logical fragmentation (as you've discovered). When you run a DBCC SHRINKDB it moves data...
Hmm, Haven't seen this before and this is all I could find on technet: Explanation The media family spans multiple volumes. The restore operation...
Check this out: http://www.databasejournal.com/features/mssql/article.php/3347241 Karl Grambow www.sqldbcontrol.com
There are several ways in which you can achieve this but the easiest way is probably to set up a database maintenance plan and indicate that you want...
Hi Adriaan, that would be the logical thing to do in the first place. But, if I understood the question correctly, the original poster wanted to...
Separate names with a comma.
