Viewing 15 posts - 16,411 through 16,425 (of 39,970 total)
I believe that with 64 bit you still want to grant this right to the service account. You don't need AWE.
http://blogs.msdn.com/b/slavao/archive/2005/11/15/493019.aspx
April 25, 2011 at 4:48 pm
The UK had holidays Fri-Mon, so I struggled to get someone to come in and check on things this weekend. I managed to get someone to kick the mail servers...
April 25, 2011 at 4:38 pm
I think it's a simplistic way of looking at a problem. Parallel problems often use simple data stores, nothing complex, and my guess is this is a start. Over time...
April 25, 2011 at 4:30 pm
SET ROWCOUNT is supposed to be deprecated in the future. I'd try to work around it wherever you can
April 25, 2011 at 12:01 pm
mikes 7125 (4/25/2011)
April 25, 2011 at 11:59 am
Tom@Intel (4/25/2011)
I learned this same lesson last year when I lost my wife after a long battle...
April 25, 2011 at 11:57 am
Yes, check SQL Server Configuration Manager, click stop on the SQL Server database engine.
April 25, 2011 at 9:01 am
Do not change the max worker threads. That's an advanced setting, and only helps in very few and rare circumstances. The recommendation is to leave this at the default unless...
April 25, 2011 at 8:59 am
They will not be able to move the SQL files unless you shut down SQL Server. Those files are always open when the database is in use and SQL Server...
April 25, 2011 at 8:52 am
Strange. If you make the change in SSMS and then use the script button, can you run that script?
Are you use they are connecting with the same credentials?
April 25, 2011 at 8:48 am
There are plenty of posts like this out there. Please search. There are documents in Books Online that talk about the process.
It's as simple as running setup for SQL 2008,...
April 25, 2011 at 8:12 am
Does your stored procedure produce a file?
You could schedule a SQLCMD job that pipes output to a file, or a BCP job that pulls out data in a query.
The job...
April 25, 2011 at 8:10 am
Expanding volumes meaning adding new space or moving the volume to a large underlying disk structure?
If it's just expanding space, it shouldn't touch existing files and you ought to be...
April 25, 2011 at 8:09 am
there is a a white paper that talks about performance of Filestream v in database storage. Not completely applicable, but it basically says files < 256kb perform better from the...
April 25, 2011 at 8:07 am
Viewing 15 posts - 16,411 through 16,425 (of 39,970 total)