WayneS

Forum Replies Created

Viewing 15 posts - 5,011 through 5,025 (of 5,588 total)

RE: Having problem getting rid of index scan in procedure

Gianluca Sartori (7/17/2009)
WayneS (7/16/2009)
I find this theory interesting, since the columns that are in the where clause are not in the tables that are producing scans.
It doesn't matter, the optimizer...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 17, 2009 at 2:19 am

#1026052
RE: sql cmd utility

You've given us almost no information with which to help you. What is the error message? What are the scripts? How are you trying to call them from sqlcmd? Since...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 17, 2009 at 2:15 am

#1026051
RE: creating table and copying fields

Out of curiousity, what was your solution?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 16, 2009 at 9:15 pm

#1025979
RE: Having problem getting rid of index scan in procedure

Lamprey13 (7/16/2009)
Tough to say. Presumably SQL thinks it is faster to SCAN than to SEEK and then do a bookmark lookup. Perhaps you could try a covering index?
On Instructor try...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 16, 2009 at 6:35 pm

#1025969
RE: Having problem getting rid of index scan in procedure

Jack Corbett (7/16/2009)
I wonder if you might be better off breaking it down into some steps using temp tables.
Jack, I see we're thinking alike here...
You reference the transaction_update...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 16, 2009 at 8:48 am

#1025713
RE: Having problem getting rid of index scan in procedure

Gianluca Sartori (7/16/2009)
You can't. Or, at least, I don't know how you could.
The scan is due to the OR to include NULL values for processed_flag and reviewed. Using ISNULL or...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 16, 2009 at 8:30 am

#1025698
RE: Statement for inserting ar rowid to an existing table

info (7/13/2009)
Thank you for your help.
I will try what you mentioned.
When you say "your text file", would that be my table name?
No, that means some text file...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 15, 2009 at 2:55 pm

#1025373
RE: Statement for inserting ar rowid to an existing table

Actually, it will number the existing rows in physical order starting at the seed, which you have specified to be 1.
Try this out for an example:
CREATE TABLE #tmp (TextData varchar(max))
BULK...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 13, 2009 at 9:02 pm

#1024219
RE: Help us tune a query

GSquared (7/13/2009)
Table variables are always estimated as if they were going to only have 1 row in them. That will give you a very false low on the cost,...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 13, 2009 at 5:59 pm

#1024189
RE: Dynamic sql Error message when executing a Stored procedure

meo2 (7/13/2009)
Hi,
I am trying to execute a paramtrized stored procedure, it works fine when @IncludeDeleted = 1
but it gives an error message when it is set to 0
"Msg 137,...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 13, 2009 at 5:41 pm

#1024180
RE: Cannot drop a constraint for temp table

I ran across this.. maybe it applies?
http://support.microsoft.com/kb/933097
See bug# 50000874
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 11, 2009 at 10:14 pm

#1023570
RE: Cannot drop a constraint for temp table

why weren't they destroyed when the stored proc completed on the 2nd July. Even if the proc bombed out with an error I would have thought the local temp table...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 11, 2009 at 7:08 pm

#1023564
RE: Wildcard search for column names

Lowell (7/11/2009)
here is a simple procedure i use all the time;
stick in the master database, and because it starts with "sp_" and uses the catibility views, it will be...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 11, 2009 at 6:59 pm

#1023563
RE: Help With a Cursor Please

text
Variable-length non-Unicode data in the code page of the server and with a maximum length of 2^31-1 (2,147,483,647) characters. When the server code page uses double-byte characters, the storage...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 10, 2009 at 9:19 pm

#1023443
RE: Select Where Any Column Equals (or Like) Value

I'm curious as to the business case for doing this. It sounds to me like you need to have your data normalized better.;-)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
Links:
For better assistance in answering your questions
Performance Problems
Common date/time routines
Understanding and Using APPLY Part 1 & Part 2

July 10, 2009 at 5:37 am

#1022960

Viewing 15 posts - 5,011 through 5,025 (of 5,588 total)