Viewing 15 posts - 42,841 through 42,855 (of 49,552 total)
As a wild guess, parameter sniffing, but it's impossible to say anything for sure without seeing the code.
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
November 28, 2008 at 4:28 am
bhuvnesh.dogra (11/28/2008)
or you have any alternative to do database shrinking ?
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in...
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
November 28, 2008 at 4:26 am
Why do you want to shrink? Databases tend to grow as more data gets put in them.
Shrinking causes massive fragmentation and will just result in the data file growing...
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
November 28, 2008 at 4:25 am
The line SELECT BuildID AS [@BuildID] is actually naming the return column @BuildID, not assigning the value to the variable. To do the assignment, you need to do it like...
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
November 28, 2008 at 4:23 am
As a wild guess, you're trying to insert a duplicate primary key value. ie, you're trying to insert a value for ClientID that's already there. Primary key must be unique.
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
November 28, 2008 at 4:17 am
You should only restore the log backups that were taken after the full backup. Not before.
Why bulk-logged? Are you doing lots of bulk operations?
If you create a DB in 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
November 28, 2008 at 4:01 am
Truncation can occur any time you're inserting from a wider column into a narrower column. In the insert statement you posted, you're doing that 4 times.
You're inserting a varchar(255) (Client)...
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
November 28, 2008 at 3:57 am
I read your first post just fine, thank you.
Is the 2-column key just because of that, or is there another reason you can't have a 2-column unique key (with...
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
November 28, 2008 at 12:54 am
skyw (11/27/2008)
Is taking the database offline and then deleting it an option at all? (rather than bringing it to the single-user mode and then deleting it.)
Sure.
ALTER DATABASE SomeDB SET OFFLINE...
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
November 28, 2008 at 12:38 am
v.reddy (11/27/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
November 28, 2008 at 12:35 am
I'm not sure there's a good way in SQL 2005.
Why can't you make the combination of the two columns unique?
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
November 28, 2008 at 12:32 am
rbarryyoung (11/27/2008)
Actually, Plan Guides might be able to do this. Unfortunately, I missed that session at PASS.
Only if a hint will help the query, and only if its one...
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
November 28, 2008 at 12:23 am
lrams99 (11/27/2008)
Hi GuysIf you have any idea in this issue, Please give some tips onthis..and detailed process
Please post a new thread with your question and don't hijack a completely unrelated...
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
November 28, 2008 at 12:18 am
v.g.mujumdar (11/27/2008)
Please tell me why this message occured? is this error? How can I understand that my replication is running normally?
It's not an error. In transactional replication the snapshot's...
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
November 27, 2008 at 2:27 pm
Yup, because a proc doesn't have a defined output. It's possible to have a procedure that returns various different resultsets (or none at all) depending on parameters passed.
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
November 27, 2008 at 2:14 pm
Viewing 15 posts - 42,841 through 42,855 (of 49,552 total)