Viewing 15 posts - 15,361 through 15,375 (of 39,824 total)
SanDroid (8/10/2011)
SanDroid (8/10/2011)
SQLRNNR (8/10/2011)
The question was to point out fragmentation that could occur from shrinking the database. Did you know that shrinking your database was detrimental?
The catgory was Administration and...
August 10, 2011 at 10:26 am
jay holovacs (8/10/2011)
Social animals (and humans are the...
August 10, 2011 at 10:13 am
Tom.Thomson (8/9/2011)
This is a great editorial, but even so it fails to address the whole problem. . . .
Good point, but not trying to address the whole problem. Designing security...
August 10, 2011 at 10:10 am
Grant is correct, you aren't giving enough information. Is there monitoring on the new server for backups? If so, how does that work? Perhaps they are the same.
It doesn't have...
August 10, 2011 at 9:52 am
Set the min low, maybe 1024MB (1GB) and then go from there. The max is usually more important.
If this is x86, 32 bit (and I think it is), then you...
August 10, 2011 at 9:50 am
Excellent question, Ron. I've used this type of demo in presentations before.
August 10, 2011 at 9:24 am
It looks like you have 8GB of RAM in the server and have the min for SQL Server set to 7GB?
I wouldn't set the minimum at all. Leave it...
August 9, 2011 at 6:36 pm
AFAIK, if you assign these to the same value, you can only store decimals. The scale (2nd param) is allowing for that many decimal points to the right, which means...
August 9, 2011 at 5:30 pm
Not in SQL Server, but I have used these in DB2 and they were very handy for processing things like end of month loads. We had a host hypervisor that...
August 9, 2011 at 5:25 pm
So the hint is being submitted in the T-SQL?
I'm not sure you can override this without removing the hint from the code. I believe the hints in the query are...
August 9, 2011 at 5:24 pm
How to: Debug T-SQL Using the SQL Server Management Studio - http://msdn.microsoft.com/en-us/library/ms241871%28v=VS.80%29.aspx
August 9, 2011 at 5:11 pm
I know this is late, but you could pass the location to the client program, but it's strictly the client program that would have to find that point in the...
August 9, 2011 at 12:46 pm
SQLJocky (8/9/2011)
Steve Jones - SSC Editor (8/9/2011)
August 9, 2011 at 11:49 am
@SQLFRNDZ (8/9/2011)
Steve Jones - SSC Editor (8/9/2011)
You can't put an Oracle login on the local side
Might be I'm understanding wrong but
You can have the Oracle Login on local...
August 9, 2011 at 11:47 am
Viewing 15 posts - 15,361 through 15,375 (of 39,824 total)