WayneS

Forum Replies Created

Viewing 15 posts - 4,711 through 4,725 (of 5,588 total)

RE: Performance issue

Chim Kalunta (2/23/2010)
It would appear that the clause:
inner join WhitePage w on w.displayname = a.displayname or w.eid = a.eid
is forcing a Clustered Index Scan on the Whitepage table. Thats where...
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

February 25, 2010 at 8:21 am

#1125028
RE: Timing is Everything

GSquared (2/25/2010)
But I'm also one of those freaks who wants the US to switch to metric measures and 24-hour clocks and should get rid of daylight savings time.
You mean there's...
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

February 25, 2010 at 8:06 am

#1125014
RE: Procedure with cursor is much faster that without cursor(With memory table and a while loop).

Joy Smith San (2/25/2010)
Thought memory tables would be faster, hence used it.
You might want to check out this article[/url]
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

February 25, 2010 at 7:17 am

#1124958
RE: Parse Column with . Delimiter

FYI, if your data would ALWAYS have 3 periods in there, you could use the ParseName function to return the position that you wanted.
i.e.:
DECLARE @x VARCHAR(80)
SET @x = '400.367.369.379'
select PARSENAME(@x,...
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

February 25, 2010 at 7:10 am

#1124950
RE: Parse Column with . Delimiter

Thanks for responding back on how you resolved it.
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

February 25, 2010 at 7:09 am

#1124948
RE: Dude, Your Fly is Open

Very good article Tim.
majorbloodnock (2/25/2010)
I'll also suggest a good rule of thumb (closely linked with Tim's point) is to criticise privately and congratulate publicly.
and might I add to the congratulate...
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

February 25, 2010 at 7:02 am

#1124941
RE: FizzBuzz

reidres (2/24/2010)
...Gianluca's unpivot works for 1 000 000 rows only, no more or less. So it is not scalable nor flexible--and who only wants a million rows?
That would 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

February 25, 2010 at 6:49 am

#1124928
RE: FizzBuzz

CirquedeSQLeil (2/24/2010)
WayneS (2/24/2010)
FYI, Gianluca's unpivot works the fastest on my system (813ms), though Lynn's is right behind (833ms) - initial runs. But, when run repeatedly (and randomly), they actually flip-flop...
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

February 25, 2010 at 6:44 am

#1124923
RE: Procedure with cursor is much faster that without cursor(With memory table and a while loop).

You will only need one of those where conditions, but you will need all 4 in the join between the tables. The query itself looks fine.
You should also test whether...
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

February 25, 2010 at 5:09 am

#1124867
RE: FizzBuzz

FYI, Gianluca's unpivot works the fastest on my system (813ms), though Lynn's is right behind (833ms) - initial runs. But, when run repeatedly (and randomly), they actually flip-flop back and...
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

February 24, 2010 at 9:15 pm

#1124738
RE: Problems with Date Searches

Tom, I think that the "<" and ">", when inside the sql code window, get converted into xml tags: "& lt;" and "& gt;" (without the spaces). I'll bet this...
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

February 24, 2010 at 2:12 pm

#1124589
RE: Are the posted questions getting worse?

Paul White (2/24/2010)
WayneS (2/24/2010)
Something that you're about to write an article on?
Oh highly amusing, Wayne! :laugh:
But Paul.... I'm serious!
BTW, I know you've told me before how you get the...
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

February 24, 2010 at 1:20 pm

#1124551
RE: Problems with Date Searches

ekant_alone (2/24/2010)
i am little curious
can't we use 'year' function in where clause?
Yes, you can use it.
But let me show you why you shouldn't.
First, let's create a test 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

February 24, 2010 at 1:02 pm

#1124539
RE: select statement with inner join returns more rows than equivalent update?

Use the OUTPUT clause on the UPDATE statement to return back the rows being updated.
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

February 24, 2010 at 12:08 pm

#1124480
RE: Parse Column with . Delimiter

The following code is another way of doing it.
You might want to look at the first link in my signature for better ways to post to make it easier for...
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

February 24, 2010 at 12:04 pm

#1124474

Viewing 15 posts - 4,711 through 4,725 (of 5,588 total)