Viewing 15 posts - 44,956 through 44,970 (of 49,552 total)
A single IO (64kb) taking longer than 15 seconds is never acceptable, no matter what may be running. What that warning means if that in the course of 2 minutes...
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
August 19, 2008 at 12:46 am
No, 2000 didn't complain about that. It was laxer on what it considered valid SQL syntaax, leading to the occasional oddity
What it's complaining about is that there are two columns...
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
August 18, 2008 at 3:09 pm
SQL 2000 only keeps track of the create date.
select crdate from sysobjects where xtype='U'
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
August 18, 2008 at 2:58 pm
"The network has issues"
Networks don't have issues, they have problems. Magazines have issues (weekly or monthly).
Though, given the state of the network, hinting that in only worked properly once 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
August 18, 2008 at 2:34 pm
KTG (8/18/2008)
Can't the data on a single page be fragmented?
Defragging an index means to put the pages of that index back into logical order. If there's only one page then...
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
August 18, 2008 at 11:00 am
Sandy (8/18/2008)
Gail,Can you please make it little more clear..
Can I make what more clear?
Gail, I have checked, the log file is there..
Can you tell me why again this error?
100% sure?...
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
August 18, 2008 at 10:36 am
bhuvnesh.dogra (8/18/2008)
hey ...how did it happen ? my question became QUESTION OF THE DAY..but without my name? :unsure::unsure:
Actually, it didn't. You posted this on the 14th Aug. 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
August 18, 2008 at 10:33 am
Schadenfreude-Mei (8/18/2008)
Just creating new SQL logins may be an issue if SQL logins (from 2000) own schemas or are dbo's etc (this is because their SID's will be different).
The...
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
August 18, 2008 at 4:51 am
The shrink can only reduce the file space if there is free space within the file. If there's no free space, the file can't be shrink. It's not compression 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
August 18, 2008 at 4:45 am
Sounds about right for a while loop.
Could you post the code here and we'll help you do whatever it is without a while loop. It's usually possible and almost always...
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
August 18, 2008 at 4:37 am
Query analyser's asking for the login's password. All that's happening with enterprise manager is that it remembers the passwords when you add the servers to the tree. A person needs...
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
August 18, 2008 at 2:16 am
Insert into Table1 (col1, col2, col3, col4)
select ColB, 45, ColA, getdate() FROM Table2
If you want the default value as specified in the table to go into the column, don't...
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
August 18, 2008 at 2:14 am
DBCC IND is an undocumented command that shows internal details of the index. It's not really useful to someone getting started.
I would suggest you read the sections in books Online...
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
August 18, 2008 at 1:54 am
Let me guess. Full recovery mode, no log backups.
Not enough info right now to give useful advice. You can read the following for background info.
http://sqlinthewild.co.za/index.php/2008/07/23/recovery-model-and-transaction-logs/
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
August 18, 2008 at 1:49 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/Topic554115-149-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
August 18, 2008 at 1:46 am
Viewing 15 posts - 44,956 through 44,970 (of 49,552 total)