Viewing 15 posts - 38,281 through 38,295 (of 49,552 total)
RichardB (6/22/2009)
and the ever irritating dtproperties.
Oh, right, the database diagrams table. I believe to get rid of those you need to filter using ObjectProperty with the IsMSShipped property. I think...
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
June 22, 2009 at 5:18 am
RichardB (6/22/2009)
GilaMonster (6/22/2009)
Actually, for SQL 2005 the easiest way is to use sys.tables.
SELECT COUNT(*) FROM sys.tables
Which is fine, as long as you remember that it also includes the occasional system...
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
June 22, 2009 at 4:50 am
That's 800 lines of code there.
Using a cursor is bad regardless of whether it's on a temp table or a real table. As for fire-hose or read-only, neither. Your...
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
June 22, 2009 at 4:34 am
Actually, for SQL 2005 the easiest way is to use sys.tables.
SELECT COUNT(*) FROM sys.tables
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
June 22, 2009 at 4:31 am
jordonpilling (6/21/2009)
1) put the database into simple before rebuilding the task, then back to full afterwards?
If you do that, you'll have to take a full backup after switching back to...
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
June 22, 2009 at 4:16 am
saidwarak01 (6/15/2009)
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
June 22, 2009 at 4:12 am
Jeff Moden (6/21/2009)
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
June 21, 2009 at 12:30 pm
caselig (6/21/2009)
That's just it. What is the instance_name?
No idea. That's why I'm asking to see the name of the Windows service.
Also to check that it's running.
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
June 21, 2009 at 6:31 am
Go to Services (Start-Control Panel-Administrative tools) and look for a service that has SQL Server in the name. Post the exact name of that service here (or take a screenshot...
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
June 21, 2009 at 6:08 am
JamesNZ (6/21/2009)
This almost seems like a problem with SQL Server then in what I've experienced :crazy:
It's not a bug, if that's what you're asking. In 99% of the cases 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
June 21, 2009 at 5:32 am
Right. That's snapshot replication. No sign of transactional replication. (it has a different icon for the publication)
Since snapshot replication doesn't use the tran log, running sp_repldone would not have broken...
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
June 21, 2009 at 5:08 am
ps (6/21/2009)
Gail, I think he is running Transaction replication coz i asked him to make a transaction and it replicated to subscriber in almost no time.
Check the output of syspublications...
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
June 21, 2009 at 4:43 am
Have you looked through SQL Books Online for information on cluster installation?
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
June 21, 2009 at 3:06 am
ps (6/20/2009)
he can also connect his named instance on local machine by typing.\instance_name
OR
127.0.0.1\instance_name
Assuming he knows what the instance name is.
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
June 21, 2009 at 3:02 am
If I'm understanding you correctly, this is not completely fixed. You're running only snapshot replication. Snapshot replication DOES NOT use transaction log. Hence the reference to replication in log_reuse and...
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
June 21, 2009 at 3:01 am
Viewing 15 posts - 38,281 through 38,295 (of 49,552 total)