Viewing 15 posts - 2,296 through 2,310 (of 5,393 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,...
-- Gianluca Sartori
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...
-- Gianluca Sartori
November 28, 2011 at 5:46 am
The server is 64 bit, you don't need AWE. Leave it unchecked.
-- Gianluca Sartori
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...
-- Gianluca Sartori
November 28, 2011 at 4:03 am
Duplicate post. Replies here please.
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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?
-- Gianluca Sartori
November 28, 2011 at 2:15 am
Looks like a good scenario for transactional replication, at least on the (2008 publisher) + (2005 subscriber) side.
-- Gianluca Sartori
November 25, 2011 at 10:18 am
Jeffrey Williams 3188 (11/25/2011)
If you...
-- Gianluca Sartori
November 25, 2011 at 10:12 am
wuze_ (11/25/2011)
But when I run...
-- Gianluca Sartori
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.
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
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...
-- Gianluca Sartori
November 25, 2011 at 6:13 am
Viewing 15 posts - 2,296 through 2,310 (of 5,393 total)