Viewing 15 posts - 45,436 through 45,450 (of 49,552 total)
Please don't use all caps. It's the online equivalent of shouting at someone.
sqldba.hl (7/26/2008)
hI ,PLEASE WRITE A SYNTAX FOR EACH QUESTION ASAP
Why? Is this for a test or interview?
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
July 26, 2008 at 9:49 am
Sounds like a good plan.
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
July 26, 2008 at 9:34 am
Dynamic SQL is about the best solution for performance for this type of query. Though it does bring its own complexities. Apologies, I was under the impression that you were...
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
July 26, 2008 at 9:33 am
From a look at it, the performance you have is probably the best you're going to get. Between the SELECT * and the complex where clause, you're looking at an...
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
July 25, 2008 at 10:46 am
In general, wider nonclustered indexes are more useful than narrow. You want the indexes to satisfy as much of the where clause of the queries as possible.
Can you post 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
July 25, 2008 at 10:40 am
Is one of those full and log backup the DB with the really large log file? If so, the reason that the log has grown to that size if that...
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
July 25, 2008 at 10:39 am
Jr.DBA (7/25/2008)
Yes,It is a full recovery model. The transaction log backups and replication are running.Thanks
Hmm. Check that the tran log backups really are running. Check that the replication log reader...
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
July 25, 2008 at 10:29 am
Have you considered replication? Yes, there is a small overhead, but you can transfer the data realtime or on demand and you don't have to recreate or change the procedures/views/functions.
Plus,...
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
July 25, 2008 at 10:22 am
Is the database in full recovery mode?
Do you have transaction log backups running?
Do you have replication running?
What is the recovery requirements for this DB in the case of failure? (ie,...
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
July 25, 2008 at 10:07 am
It's used by the replication log reader, to mark that it has read and replicated a set of commands. You can use it if there's problems with replication, but that'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
July 25, 2008 at 9:56 am
It's posted in 2 different forums on the same site, posted at the same time. That's what I mean by cross post.
It's been standard internet etiquette since the early...
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
July 25, 2008 at 9:53 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic540764-364-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
July 25, 2008 at 3:41 am
Mike Baria (7/24/2008)
I'm embarassed to ask, but here-goes:
Don't be embarassed. We all had to start somewhere. The only stupid question is the one that's not asked.
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
July 25, 2008 at 1:13 am
Don't worry too much about using these on a dev server (that's assuming you have enough rights to use them in the first place)
Slow running queries won't hurt 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
July 25, 2008 at 1:11 am
MrBaseball34 (7/24/2008)
I guess I could if I knew *what* to tell them.
🙂 Basically, that form of query has no single optimal plan and it tends to confuse the query optimiser....
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
July 25, 2008 at 12:59 am
Viewing 15 posts - 45,436 through 45,450 (of 49,552 total)