Viewing 15 posts - 21,136 through 21,150 (of 22,196 total)
I'm not sure why you're getting the collation errors. One of the columns must be marked differently. How about this as a query:
select p.name
...
January 28, 2008 at 11:01 am
That's elapsed time on the client then. Have you looked at the execution plans?
January 28, 2008 at 10:50 am
Sorry, I didn't read the whole post (again).
That is odd. Where are you measuring the time elapsed, the server or the client?
Have you looked at the execution plan? Maybe most...
January 28, 2008 at 8:04 am
Probably because most of the time is spent in martialing the rows of data, not particular columns.
January 28, 2008 at 7:50 am
The problem with dynamic queries is that they can lead to recompiles and poor plan reuse. While they solve some problems, they can introduce others.
January 28, 2008 at 7:46 am
Imke Cronje (1/28/2008)
Checked out execution plan and its shows this:
Query Cost (relative to batch) : 100%
Estimated Operator Cost: 99...
January 28, 2008 at 7:43 am
Basically the case statement is resolving either to 1 or 0. If it's 1, then 1=1 at the end of the case statement. If it's zero, then 0 certainly does...
January 28, 2008 at 6:06 am
And the execution plan?
Plus, how often does the index get rebuilt or the statistics get updated?
January 28, 2008 at 6:00 am
Further, since as you say this isn't your database, if the owner has set up security appropriately, you probably won't have DDL permissions.
January 28, 2008 at 5:52 am
Everything everyone else said is 100% true. Just understand that if you don't need case sensitivity, using it just to be cool can add an incredible amount of overhead to...
January 28, 2008 at 5:49 am
Designing web pages & managing databases are two different beasties. But since you ask, I have all of the Inside SQL Server 2005 series sitting on my desk, well thumbed...
January 28, 2008 at 5:45 am
We've actually got a method that does this pretty well. We try to use it sparingly, but some of our reports from some of our systems have legitimate requirements to...
January 28, 2008 at 5:42 am
And be sure to check the execution plan to be sure that indexes are being used at all.
January 28, 2008 at 5:36 am
Even if you don't explicitly state a return value, all stored procedures have one. I prefer to do something along these lines in 2005 (similar, but different error handling, in...
January 27, 2008 at 10:38 am
As the size of the database increases, sp_updatestats can degrade pretty seriously. You may need to identify those particular tables or indexes that need more frequent updates and use UPDATE...
January 27, 2008 at 10:34 am
Viewing 15 posts - 21,136 through 21,150 (of 22,196 total)