Viewing 15 posts - 2,296 through 2,310 (of 5,394 total)
Steve Jones - SSC Editor (11/28/2011)
I'm baaaaaackkkkkImmunity granted to all problems in the Thread over the last week. No way I'm going through the last week of posts.
Moderate pants talk,...
November 28, 2011 at 7:29 am
I'm a bit confused.
If I understand correctly, you are trying to pass a table valued parameter to a stored procedure and insert the rows into two different tables (table_a and...
November 28, 2011 at 5:46 am
The server is 64 bit, you don't need AWE. Leave it unchecked.
November 28, 2011 at 4:16 am
SQL_Helper (11/28/2011)
I want to set Maximum memory limit as 60 GB to SQL Server
sp_configure 'max server memory (MB)', 60000
Please also suggest what will be the best value for minimum memory...
November 28, 2011 at 4:03 am
Duplicate post. Replies here please.
November 28, 2011 at 2:46 am
SQL_By_Chance (11/25/2011)
The data is normalized but I have concatenated fields separated by "/".
Oxymoron. The former or the latter, it can't be both at the same time.
I wanted to know if...
November 28, 2011 at 2:33 am
This means that your SQL Server instance will read 59 GB of data every 410 seconds (it's a simplification, search Page Life Expectancy in Google and read something on the...
November 28, 2011 at 2:27 am
I suppose your question is not important enough to post it properly.
Did you read the article I suggested?
November 28, 2011 at 2:15 am
Looks like a good scenario for transactional replication, at least on the (2008 publisher) + (2005 subscriber) side.
November 25, 2011 at 10:18 am
Jeffrey Williams 3188 (11/25/2011)
If you...
November 25, 2011 at 10:12 am
wuze_ (11/25/2011)
But when I run...
November 25, 2011 at 8:56 am
Apply Service pack to the newly added node. It will only update binaries installed on that node.
The databases have already been upgraded by your previous SP install.
November 25, 2011 at 8:53 am
You can use a character splitter function such as the one described by Jeff Moden in his excellent article[/url].
Please note that if you're doing this, you're probably violating 1NF. Consider...
November 25, 2011 at 6:33 am
Permissions don't "get lost", but may be revoked by something:
1) Explicit REVOKE commands
2) Drop / re-create view
Personally, I would investigate the drop/re-create as the most likely cause, then I would...
November 25, 2011 at 6:17 am
Multiple tempdb data files allow mitigating contention issues, but memory allocation is a whole different story.
Read this page on Paul Randal's blog for more information on tempdb file I/O contention.
For...
November 25, 2011 at 6:13 am
Viewing 15 posts - 2,296 through 2,310 (of 5,394 total)