Viewing 15 posts - 30,466 through 30,480 (of 49,552 total)
Half-configured transactional replication. Wish I knew why. Easy to fix
Create a transactional replication publication
Publish a single table (a small one)
Stop the log reader
New query (in that DB) and run exec...
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
September 21, 2010 at 2:00 pm
What do you want to happen to numbers like this:
1.45
1.48
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
September 21, 2010 at 1:52 pm
No, you do not need or want the log reader running for snapshot. Are there supposed to be any transactional replication publications on that database?
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
September 21, 2010 at 1:40 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic990695-391-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
September 21, 2010 at 1:33 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic990695-391-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
September 21, 2010 at 1:33 pm
Your application is using a connection string for windows authentication and, as the error says, the domains aren't trusted.
Either ask the domain admin to set up the required trust between...
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
September 21, 2010 at 1:31 pm
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic990695-391-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
September 21, 2010 at 1:30 pm
Round up? If you round 1.434567 up, it'll be 1.5, not 1.4.
Can you clarify your requirement?
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
September 21, 2010 at 1:18 pm
dbowlin (9/21/2010)
I will probably go with one of the editors, but it could be anyone.....even me!
One of the editors? The only editor here is Steve. The rest of us are...
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
September 21, 2010 at 1:14 pm
CirquedeSQLeil (9/21/2010)
We now need 15.72 posts/day for 20kGail needs 14.52 posts/day for 20k
Currently I seem to be doing something like 20-25/day.
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
September 21, 2010 at 1:06 pm
Craig Farrell (9/21/2010)
That's part of the minimally built database I've seen mention of that builds at 64kb or something similar?
Huh?
CheckDB snapshot is created when checkDB starts and dropped as soon...
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
September 21, 2010 at 1:05 pm
The evaluation edition (which is enterprise) can be installed on any OS.
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
September 21, 2010 at 11:42 am
Didn't miss it, but was trying to get out to usergroup meeting.
I wouldn't recommend changing compat level. Could cause queries to change behaviour or break. However, what people often 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
September 21, 2010 at 11:34 am
Tracing for 8 hours gives you far more data than you can manage. If you read the articles i wrote, you'll see i recommend 30-60 minutes at a time. How...
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
September 21, 2010 at 11:20 am
Craig Farrell (9/21/2010)
http://msdn.microsoft.com/en-us/library/ms188796.aspxThe following DBCC commands operate on an internal read-only database snapshot that the Database Engine creates.
If you're interested, the snapshot is created using the NTFS alternate stream...
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
September 21, 2010 at 11:18 am
Viewing 15 posts - 30,466 through 30,480 (of 49,552 total)