Viewing 15 posts - 15,436 through 15,450 (of 39,902 total)
Brandie Tarvin (8/10/2011)
This one is giving me heartburn. I almost ran something in Production that was supposed to...
August 10, 2011 at 12:08 pm
It's possible, but I doubt we would spend much time on this. Ultimately we don't expect you do use the code from the iPhone since a cut/paste doesn't make a...
August 10, 2011 at 11:54 am
I have updated and corrected the script and included a create database statement. This does show fragmentation of .39% and 90+% if you run this in a newly created database...
August 10, 2011 at 10:29 am
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
Viewing 15 posts - 15,436 through 15,450 (of 39,902 total)