Viewing 15 posts - 45,751 through 45,765 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 12, 2008 at 6:13 am
Jeff Moden (7/11/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 12, 2008 at 6:04 am
Does the SQL service account have rights to connect to the share on Server A?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 11, 2008 at 3:17 pm
Carl Federl (7/11/2008)
create table...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 11, 2008 at 3:11 pm
Check what perfmon says.
Process:Working set (and select sqlservr.exe)
Also check the total and target server memory (I think that's under SQL Server memory manager. It's under one of the SQL...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 11, 2008 at 3:06 pm
Makes no difference. The order you specify the columns just determines the columnIDs, no guarantees that the columns will actually be stored in that order in the data pages.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 11, 2008 at 3:01 pm
Set up profiler, monitor failed logins and make sure you get the hostname and applicationname columns. That should show you where the logins are coming from.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 11, 2008 at 2:58 pm
Viewing 15 posts - 45,751 through 45,765 (of 49,552 total)