WayneS

Forum Replies Created

Viewing 15 posts - 4,201 through 4,215 (of 5,588 total)

RE: Free Advice or Free Consulting

Very well done Grant! There was a lot of "yeah!" moments in there.
Thanks!
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

May 13, 2010 at 4:42 am

#1166755
RE: Are the posted questions getting worse?

Does anyone know of a FireFox (3.6.3) Add-on that provides a toolbar for supporting enhanced text fields (where you can directly format the text in a field) , such as...
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

May 12, 2010 at 5:40 pm

#1166582
RE: Get XML into TSQL variable

set @YourVar = ((select ... FOR XML))
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

May 12, 2010 at 3:42 pm

#1166561
RE: Help with re-writing a cursor to a set based solution

Jim,
In order to help you replace this with a set-based routine, we will need the following information from you:
1. DECLARE @ModelJob TABLE statement (so we know the structure of what...
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

May 12, 2010 at 1:18 pm

#1166490
RE: Are the posted questions getting worse?

Roy Ernest (5/12/2010)
Anyone seen our resident CHIPMUNK? I havent seen or heard from him for a long time. I havent seen his tweets either. Anybody any clue?
Hmm, his last post...
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

May 12, 2010 at 12:38 pm

#1166465
RE: Are the posted questions getting worse?

Steve Jones - Editor (5/12/2010)
There are always new people, which is why we reprint older, good articles from the past at times. Nobody sees everything, and there is a need...
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

May 12, 2010 at 9:45 am

#1166330
RE: Do you know your getdate()?

JacekO (5/12/2010)
Wow.
I did not expect to get so many posts before I even show up for work.
Looking at all the replies, one potential explanation for some 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

May 12, 2010 at 7:32 am

#1166191
RE: While Loop Much Slower than LOCAL FAST_FORWARD READ_ONLY Cursor

Robb,
A while loop is no better, and frequently worse, than a c.u.r.s.o.r.
From what you describe, Jeff's article (that Lutz mentioned above) should handle your situation. I've seen solutions based 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

May 11, 2010 at 5:00 pm

#1165886
RE: select top 1 * from table is slow?

In addition to the above, what about a where condition. Where's on columns not in an index can force a table scan.
One common use of the top 1 is to...
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

May 11, 2010 at 4:39 pm

#1165876
RE: MCJ - The Missing Link

You can add mine also to the sharepoint site.
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

May 11, 2010 at 4:26 pm

#1165871
RE: adding single quotes around a value output by a function

Dohsan (5/11/2010)
I believe you can also use the QUOTENAME function here
http://msdn.microsoft.com/en-us/library/ms176114.aspx
SELECT'EXEC Sproc '
+ ...
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

May 11, 2010 at 10:38 am

#1165685
RE: No SFTP Task Component in SSIS 2005/2008? No Problem!

Good article.
Having that username/password in a batch file is an issue. If (for any reason, like the FTP server is down) the package fails, that file could be left behind,...
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

May 11, 2010 at 8:08 am

#1165565
RE: Who will the Exceptional DBA in 2010?

Lynn Pettis (5/10/2010)
Who else is going to listen to the problems we have encountered and how we solved them, or what accomplishments we may have achieved at work? My...
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

May 10, 2010 at 10:40 pm

#1165331
RE: Are the posted questions getting worse?

Lynn Pettis (5/7/2010)
I see a trip to the TitD in the near future.
I feel for you Lynn. It's like pulling teeth in there... 🙁
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

May 7, 2010 at 2:33 pm

#1164447
RE: Need help with a query

lmu92 (5/6/2010)
WayneS (5/5/2010)
lmu92 (5/5/2010)
Might be agood idea to turn it into an article...
Yes, it would. Which reminds me... are you writing one based upon that post last year where 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

May 6, 2010 at 4:59 pm

#1163700

Viewing 15 posts - 4,201 through 4,215 (of 5,588 total)