Viewing 15 posts - 511 through 525 (of 1,790 total)
GilaMonster (8/13/2010)
4GB is the maximum amount of memory a 32 bit app can use running on a 64 bit OS.
Thanks Gail. Hate to think that this is what they did...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 13, 2010 at 6:43 am
Paul White NZ (8/13/2010)
This is a neat way of capturing that information:
select name,
value,
value_in_use...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 13, 2010 at 6:37 am
Check out this thread.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 13, 2010 at 5:17 am
Ian Ritchie (8/12/2010)
I have read a few things contradicting the sqlskills article too, just as the author suggests, so the sqlskills link clears it...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 12, 2010 at 10:58 pm
Can you post the results of the following;
USE master;
GO
EXEC sp_configure 'show advanced option', '1';
RECONFIGURE;
EXEC sp_configure;
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 12, 2010 at 2:03 pm
Ok, one more link that will be helpful with both the tempdb and file splitting information;
http://blogs.msdn.com/b/psssql/archive/2007/02/21/sql-server-urban-legends-discussed.aspx
Hope this helps.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 12, 2010 at 1:48 pm
Ian,
A couple points here;
First, before jumping out and creating lots of tempdb files it would be good to read up on what this solves and to understand what...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 12, 2010 at 1:39 pm
John Rowan (8/12/2010)
Huh, I have a good friend that lives just outside of Lockport (farm boy).
Yeah, that's about all you have up here. Farms, and hmmm, oh yeah, more farms....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 12, 2010 at 10:23 am
Paul White NZ (8/12/2010)
David Benoit (8/12/2010)
Paul White NZ (8/12/2010)
You can name constraints on # and ## temporary tables, but it is a pretty bad idea.
I haven't had a need to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 12, 2010 at 9:50 am
Ray K (8/12/2010)
David Benoit (8/12/2010)
Ray K (8/12/2010)
David Benoit (8/12/2010)
Ray K (1/12/2010)
In perusing these forums, I'm noticing a great deal of geographic...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 12, 2010 at 9:33 am
From Steve: "The only reliable method is to query each machine's registry or services for SQL services installed or running, but that's really a job for SMS or Operations Management...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 12, 2010 at 9:28 am
Ray K (8/12/2010)
David Benoit (8/12/2010)
Ray K (1/12/2010)
In perusing these forums, I'm noticing a great deal of geographic diversity (which I think...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 12, 2010 at 9:24 am
GilaMonster (8/12/2010)
Only if Builtin\Administrators is granted login and a member of the sysadmin server role.
AND if you decide to remove Builtin\Administrators make sure that you do some reading to understand...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 12, 2010 at 9:16 am
ashish.kuriyal (8/12/2010)
open cmd and runsqlcmd -L
if you want output of this in text file, lets say in c drive then :-
sqlcmd -L >c:\serverlist.txt
Cool tip. Didn't even think about using SQLCMD...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 12, 2010 at 9:07 am
Paul White NZ (8/12/2010)
You can name constraints on # and ## temporary tables, but it is a pretty bad idea.
I haven't had a need to do this (or even consider...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
August 12, 2010 at 8:48 am
Viewing 15 posts - 511 through 525 (of 1,790 total)