Viewing 15 posts - 45,766 through 45,780 (of 49,571 total)
Jeff Moden (7/12/2008)
July 13, 2008 at 11:57 pm
Ben Blum (7/13/2008)
July 13, 2008 at 11:55 pm
TRACEY (7/12/2008)
A lot of data 🙂I was trying to get it in MG to explain to people how much data they are requesting...blocks will not mean too much to them.
So...
July 12, 2008 at 9:53 am
The logical reads and writes are a count of pages, not MB, GB or other size measurements.
A page in SQL is 8kB, so if profiler tells you that for...
July 12, 2008 at 8:39 am
Pretty much, however you have made the developer the owner of that DB. That means he can do absolutely anything with it, including increasing the size of the data or...
July 12, 2008 at 6:50 am
Mayuresh (7/12/2008)
SQL SERVER 2000 SERVICE PACK 3 or 4 will solve the issue.
Since he's running SQL 2005, I seriously doubt it.
July 12, 2008 at 6:35 am
Could you post the full error message and perhaps some description of where and how you get it?
July 12, 2008 at 6:34 am
Please don't cross post. It just wastes people's time and fragments replies. Many of us read all the forums
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic532987-150-1.aspx
July 12, 2008 at 6:30 am
Are they happening at regular intervals? It may be worthwhile running profiler for a while to see where the commands are coming from and from who.
The things that cause that...
July 12, 2008 at 6:27 am
Create a login for the developer (preferably using windows authentication) Do not assign the login to any of the fixed server roles. Map that login to a database and grant...
July 12, 2008 at 6:14 am
Because it throws away the inactive portion of the transaction log. Fine if you don't care about recovering to a point in time after the change to simple, a really,...
July 12, 2008 at 6:13 am
Jeff Moden (7/11/2008)
July 12, 2008 at 6:07 am
Jeff Moden (7/11/2008)
One thing we can agree on... the problems that appear on the forum because of the new datatypes will be interesting. 🙂
Absolutely.
The number of ways to abuse a...
July 12, 2008 at 6:04 am
Does the SQL service account have rights to connect to the share on Server A?
July 12, 2008 at 5:59 am
Checkpoint occur at intervals based on the activity in the database and the specified recovery interval (default 1 min, I believe). The more activity, the more frequent the checkpoints.
Very simple,...
July 11, 2008 at 3:17 pm
Viewing 15 posts - 45,766 through 45,780 (of 49,571 total)