WayneS

Forum Replies Created

Viewing 15 posts - 2,131 through 2,145 (of 5,588 total)

RE: help in my procedure

CELKO (12/15/2010)
>> There's math problems with money? Please, do tell. I haven't heard anything about them and as I use that field [sic: columns are not fields] quite a bit,...
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

December 15, 2010 at 3:00 pm

#1263181
RE: How do I know when to use temp tables/table variables?

Tom.Thomson (12/15/2010)
WayneS (12/15/2010)
[Sigh]
So many people need to see my presentation... maybe at SQL Rally??? I'm counting on you guys to vote for it next month!
[/Sigh]
Wayne, I wish I could get...
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

December 15, 2010 at 2:48 pm

#1263174
RE: help in my procedure

CELKO (12/15/2010)
ISO makes its money from selling documents. ANSI makes its money from membership fees. Other national Standards bodies are government agencies and get tax money.
If you go on-line...
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

December 15, 2010 at 1:08 pm

#1263113
RE: SELECT All Columns from a table - without re-engineering if table stucture changes

CirquedeSQLeil (12/15/2010)
WayneS (12/15/2010)
Toby Harman (12/14/2010)
If all you are doing is writing that data out to another file and you *always* want *every* column, then SELECT * would be fine.
If you...
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

December 15, 2010 at 1:01 pm

#1263105
RE: SELECT All Columns from a table - without re-engineering if table stucture changes

Toby Harman (12/14/2010)
If all you are doing is writing that data out to another file and you *always* want *every* column, then SELECT * would be fine.
If you can't categorically...
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

December 15, 2010 at 11:40 am

#1263052
RE: Are the posted questions getting worse?

It's Wednesday, so Celko's roaming the forums again
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

December 15, 2010 at 11:30 am

#1263048
RE: help in my procedure

CELKO (12/15/2010)
Please learn to follow ISO-11179 data element naming conventions and formatting rules. Temporal data should use ISO-8601 formats.
Hey Joe - can you send these to us, or otherwise...
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

December 15, 2010 at 11:29 am

#1263047
RE: Need some help with a large data volume optimization

Craig Farrell (12/15/2010)
WayneS (12/15/2010)
Paul White NZ (12/15/2010)
LutzM (12/15/2010)
What would it help in Craigs scenario to lock the door, dim the light and ignore the ringing bell? :unsure: 😀
The last thing...
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

December 15, 2010 at 11:24 am

#1263042
RE: Strange Temp Tables

Those are table variables. The only way to get rid of them is for the batch that declared them to stop running.
I doubt that they are the cause of why...
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

December 15, 2010 at 10:47 am

#1263025
RE: filter in join vs filter in where clause

winston Smith (12/15/2010)
I have two queries. they both return different data, despite looking very similiar. The only difference is that one of the filters has been moved out of 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

December 15, 2010 at 7:54 am

#1262859
RE: Need some help with a large data volume optimization

Paul White NZ (12/15/2010)
LutzM (12/15/2010)
What would it help in Craigs scenario to lock the door, dim the light and ignore the ringing bell? :unsure: 😀
The last thing Craig needs right...
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

December 15, 2010 at 7:17 am

#1262837
RE: Columns of second query appears in diff order when use UNION.

I'd really like to see the query you were running also... from what you've said, this shouldn't be happening. The proof is in the code. I'd be very appreciative if...
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

December 15, 2010 at 7:12 am

#1262833
RE: How do I know when to use temp tables/table variables?

Tom.Thomson (12/15/2010)
Jeff Moden (12/14/2010)I'm not sure I'd call them dangerous (by themselves, they won't cause any damage, I think) but they sure are false. Heh... it's proof positive that...
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

December 15, 2010 at 7:09 am

#1262832
RE: Are the posted questions getting worse?

Stefan Krzywicki (12/15/2010)
GilaMonster (12/15/2010)
Chris Morris-439714 (12/15/2010)
I *think* Gail has blogged on this, will look.
http://sqlinthewild.co.za/index.php/2009/08/17/exists-vs-in/
http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/
http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/
http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/
http://sqlinthewild.co.za/index.php/2010/04/27/in-exists-and-join-a-roundup/
So that is a "yes" then? : -)
Yes. 😉
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

December 15, 2010 at 6:59 am

#1262814
RE: Are the posted questions getting worse?

Gail, are you trying for sainthood?
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

December 14, 2010 at 11:00 pm

#1262630

Viewing 15 posts - 2,131 through 2,145 (of 5,588 total)