WayneS

Forum Replies Created

Viewing 15 posts - 2,146 through 2,160 (of 5,588 total)

RE: Hidden Formatting Troubles with STR() (SQL Spackle)

I've hardly used STR(), so I didn't know about all of these pitfalls. Thanks for the Spackle!
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 10:55 pm

#1262628
RE: Top N for each group in a counted series

paul.beattie (12/14/2010)
Any ideas?
Yes.
You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.)...
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 7:40 pm

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

ASDL (12/14/2010)
My question still holds how do I write this SP so that I do not have to change it in future if columns are added or deleted from 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 14, 2010 at 2:26 pm

#1262522
RE: Are the posted questions getting worse?

Stefan Krzywicki (12/14/2010)
Wow. I was having problems with an older query taking too long, so I made what I thought was a little switch to begin making time improvements. I...
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 1:52 pm

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

Paul White NZ (12/13/2010)
Typically, these are achieved by:
1. Truncating the staging table at the start of the SSIS package (an Execute SQL task)
2. Dropping any nonclustered indexes on...
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 8:21 am

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

Paul White NZ (12/13/2010)
WayneS (12/13/2010)
Did you ever do anything with that missing index on those processes in the c.u.r.s.o.r.? (Or making the CI on BatchGroup?)
I'm not dismissing the idea at...
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 8:11 am

#1262250
RE: Try to build a SQL error string, but

Now to handle what HappyCat mentioned with your code:
DECLARE @Desc VARCHAR(5000)
BEGIN TRY
-- Generate a divide-by-zero error.
SELECT 1/0;
END TRY
BEGIN CATCH
...
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 13, 2010 at 9:01 pm

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

Did you ever do anything with that missing index on those processes in the c.u.r.s.o.r.? (Or making the CI on BatchGroup?)
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 13, 2010 at 8:58 pm

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

I agree 100% with shooting down Method 3.
Your DBA is a pretty smart guy for being able to do #2. Normally, I would be inclined to agree with him. However,...
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 13, 2010 at 8:49 pm

#1262017
RE: Calling function twice in same select

How about this?
SELECT t1.NumericalRanking,
AlphaRanking
FROM (SELECT NumericalRanking = really complicated code FROM MyTables) t1
JOIN rankings...
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 13, 2010 at 11:41 am

#1261874
RE: Are the posted questions getting worse?

GilaMonster (12/12/2010)
I wonder, if I change my avatar to a photo, will I stop having people call me Mr or Sir?
That depends - do they do it in person, 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

December 12, 2010 at 1:49 pm

#1261461
RE: Advice Sought: How would you do this?

Phil,
So, something like this?
-- store off what you're doing so you can mark them as processed
DECLARE @TableNew TABLE (RowID INT IDENTITY, Col2 = PK of TABLE);
INSERT INTO @TableNew SELECT PK...
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 12, 2010 at 12:25 pm

#1261452
RE: Are the posted questions getting worse?

Tom.Thomson (12/12/2010)
Steve Jones - SSC Editor (12/11/2010)
Tom.Thomson (12/11/2010)
Celko's been at it again, and Gus's response http://www.sqlservercentral.com/Forums/FindPost1032150.aspx is unfair to monkeys.
Excellent response from Lowell and Gus.
Tom, new avatar?
Yes, it changes now...
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 12, 2010 at 12:09 pm

#1261447
RE: Date Ranges

Jeff Moden (12/11/2010)
Try this...
I knew there was a simpler way, but I just couldn't figure it out. Thanks Jeff!
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 11, 2010 at 10:21 pm

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

Paul White NZ (12/11/2010)
edit: Wayne, that query plan graphic really messes up the page - how about leaving it as an attachment?
Done, sorry about 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 11, 2010 at 10:09 pm

#1261376

Viewing 15 posts - 2,146 through 2,160 (of 5,588 total)