Viewing 15 posts - 196 through 210 (of 1,065 total)
SQLkiwi (2/24/2011)
I hadn't realized until just now that 'Ten Centuries' was your age, not points rank :w00t:
I'm indestructable.
Hold on, you're probably too young to have seen Captain Scarlet, so you...
February 24, 2011 at 12:07 pm
Does this sort of irritating Spam really work? http://www.sqlservercentral.com/Forums/Topic1068979-392-1.aspx
If I was in the market for one of those, I wouldn't buy from a company that does that sort of thing...
February 24, 2011 at 8:16 am
SQLkiwi (2/24/2011)
David Benoit (2/24/2011)
I remember when I took my first programming class, Pascal (Turbo actually)...I did a term using Turbo Pascal at University too.
OMG, that makes me feel REALLY old....
February 24, 2011 at 8:00 am
Just looking at your example data, it looks as though a very simple query will get what you want, but I suspect the requirements aren't quite as simple as you've...
February 24, 2011 at 2:02 am
Dan Colbert-387424 (2/23/2011)
I've always been taught this is an unnecessary and unmanageable practice.
Me too! I've never actually seen it done on any systems I've supported.
If this is done...
February 23, 2011 at 8:22 am
What makes you think the deadlocks are due to the amount of memory being used by SQL Server?
I think you need to look elsewhere (i.e. the SQL being run by...
February 23, 2011 at 4:58 am
You can change back to Windows and SQL Authentication by editing the registry.
Change the value for this key to 2 (it's probably 1 at the moment):-
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.[your instance name]\MSSQLServer\LoginMode
February 21, 2011 at 6:12 am
Gianluca Sartori (2/18/2011)
I apologize for provoking another forgettable page in SSC history.
Don't appologize Gianluca. That sort of behaviour needs to be brought to people's attention.
I just wish I'd seen this...
February 18, 2011 at 7:26 am
I'm not a Web Developer, so I can't comment on the rest of the code, but I did spot a potential problem in your connection string:-
Initial Catalog=my_database.mdf
You should be referring...
February 18, 2011 at 6:37 am
You can use sp_helptext xxx (where xxx is the name of your stored procedure.
You can also query the syscomments table directly.
February 18, 2011 at 4:32 am
Maybe this is what you need:-
select sum(LogsizeInMB) as TotalMB
from
(
select databasename, max(logsize) as LogsizeInMB
from dbo.logSpaceStats
group by databasename
) as logsize
February 18, 2011 at 3:31 am
If you want it to start at 1, reseed it to 0.
BEGIN DBCC CHECKIDENT ('Employee',RESEED,0) END
February 18, 2011 at 2:52 am
Gianluca Sartori (2/18/2011)
Do you remember Lennie, the guy with sock-puppets friends?He's back again. Nothing worth worrying about, at the moment.
http://www.sqlservercentral.com/Forums/Topic1066085-9-1.aspx
And I was unfortunate to see this post AFTER I'd helped...
February 18, 2011 at 2:35 am
We need a lot more information to stand much chance of helping.
When you say it doesn't work, exactly what do you mean? Are you getting an error message?
Just looking at...
February 18, 2011 at 12:57 am
The only occasion I have deliberately used a cursor solution (other than through laziness!) was for an archiving job.
The server was used 24/7, so there was no ideal time for...
February 17, 2011 at 4:41 am
Viewing 15 posts - 196 through 210 (of 1,065 total)