Viewing 15 posts - 44,851 through 44,865 (of 49,552 total)
SQL Server always uses the transaction log, and the recovery model doesn't change how much is logged (except for bulk operations). What the recovery model changes is how long 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 26, 2008 at 5:27 am
The cache refreshes automatically from time to time. I have no idea how often. I'll do some investigation and see if I can work it out.
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 26, 2008 at 5:18 am
If you go in to the properies of the job step and go to the second tab, there's an option to write out the job's output to a file. If...
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 26, 2008 at 5:15 am
You're not the first to think of this. 🙂
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=331220
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=351043
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 26, 2008 at 5:11 am
There's some underlying network problem that's preventing the principle from seeing the mirror and vis versa. Before you can fail back, you are going to have to fix the connectivity...
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 26, 2008 at 5:10 am
Dunno about configuring, but you can update the intellisense cache to include new objects. Ctr-Shift-R (or Edit->Intellisense->Refresh Local Cache)
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 26, 2008 at 5:03 am
Do all of the instances use the same service account? What accounts have the lock pages priviledge?
I would suggest you reduce the max memory for some of the instances. 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
August 26, 2008 at 5:00 am
Could you please post table creation scripts, sample data and expected output?
See - http://www.sqlservercentral.com/articles/Best+Practices/61537/
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 26, 2008 at 4:55 am
You could start with Books Online (the SQL 'help' file). There's a lot of info in there on the architecture of SQL Server. If you have questions after reading through...
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 26, 2008 at 1:52 am
Duplicate post.
Direct replies to the following thread please: http://www.sqlservercentral.com/Forums/Topic558664-146-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 26, 2008 at 1:51 am
Can you explain in more detail what you're trying to do? I'm sure someone will come up with a non-cursor approach.
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 26, 2008 at 1:41 am
Yeah, it's different in 2005 and 2008. That number's too large to be an object ID. It's actally a partitionID. To get the objectID back -
select object_id from sys.partitions...
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 26, 2008 at 1:40 am
I've seen it a couple times, but I have no idea what causes it. It doesn't happen every time a database is detached.
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 26, 2008 at 1:38 am
Yeah, that works. Sorry, I misread your question, thought you were adding a default to an existing column.
The WITH VALUES is only valid if you're adding a new column...
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 26, 2008 at 1:35 am
Be careful with DTA. It has a habit of over-recommending things. Take its recomendations with a large pinch of salt and test carefully before putting the indexes it suggests in.
I've...
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 26, 2008 at 1:08 am
Viewing 15 posts - 44,851 through 44,865 (of 49,552 total)