WayneS

Forum Replies Created

Viewing 15 posts - 4,921 through 4,935 (of 5,588 total)

RE: Are the posted questions getting worse?

Gus - definitely not looking good. Like you said, might be good or bad news. Agree with all others to start looking.
Best of luck!
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 4, 2009 at 8:33 am

#1087791
RE: Who Watches the Watchers?

Jason Miller-476791 (12/3/2009)
... It comes down to having to trust SOMEONE at some point...
Aren't these the people that you get insurance bonding for? So it really comes down 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

December 3, 2009 at 7:52 am

#1087091
RE: SSIS with Excel

From what I've read about this issue, your job step needs to be set to Operating System (CmdExec), and you have to type the full path to the 32-bit version...
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 1, 2009 at 7:32 am

#1085791
RE: T-SQL

When I run the four statements, I get:
2009-11-15 22:39:14.090 Sunday
2009-11-15 22:39:14.090 Sunday
2009-11-16 03:39:14.090 Monday
2009-11-16 03:39:14.090 Monday
Not the same day or hour. They're not returning the same values.
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

November 16, 2009 at 8:47 pm

#1080008
RE: DBCC error & need to delete rows from sys.columns table

Gail, I'm so glad that you gave such a good response here earlier. We just discovered this on one of our prod dbs, and using option 2 we were able...
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

November 10, 2009 at 5:21 pm

#1077596
RE: Having troubles connecting to one server on network

Jack Corbett (11/9/2009)
What VPN client are you using?
We've been using "The Greenbow VPN", but are shifting to "OpenVPN". Both are having this issue.
You might want to check to see 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

November 9, 2009 at 9:34 pm

#1077070
RE: Trying to UnPivot without using multiple selects unioned together

Paul White (11/1/2009)
Although the 2008 method is undoubtedly impressive, I'm very aware of the fact that it is a relatively small tweak to the original (awesome) solution from Peter. He...
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

November 2, 2009 at 6:10 pm

#1074072
RE: Trying to UnPivot without using multiple selects unioned together

Paul White (11/1/2009)
or by creating a (very reasonable) PRIMARY KEY on the RowID column of the #Update table.
I was going to ask what kind of indexes you'll thought 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

November 1, 2009 at 7:17 pm

#1073646
RE: Trying to UnPivot without using multiple selects unioned together

Bob Hovious 24601 (10/31/2009)
Wayne. Just out of curiosity, how fast would the 2008 solution run without the order by clause? The sort in the execution plan...
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

November 1, 2009 at 9:42 am

#1073594
RE: Discussion: Removing the option to ' SELECT * FROM OBJECT'

About the only time I use a select * inside code is when I've done something in a CTE that then defines the columns.
Even then, it's rare. But the point...
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

October 31, 2009 at 7:54 pm

#1073545
RE: Trying to UnPivot without using multiple selects unioned together

Even though I posted this looking for a SQL 2005 solution, I tried out Paul's newest code. And I'm happy to announce that this new bit of code has redeemed...
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

October 31, 2009 at 7:35 pm

#1073544
RE: Trying to UnPivot without using multiple selects unioned together

Attachment added to original post... I know I had it there the first time (it was the first thing I did so that I wouldn't forget), but I wonder 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

October 31, 2009 at 3:41 pm

#1073539
RE: Trying to UnPivot without using multiple selects unioned together

Bob Hovious 24601 (10/29/2009)
I wonder if, under the covers, an UNPIVOT is really just a cross join like Peter's solution.
I don't think so... it doesn't perform like one.
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

October 31, 2009 at 11:17 am

#1073519
RE: Trying to UnPivot without using multiple selects unioned together

Okay, I've finished my performance testing. See attached zip file for the code used, as well as the execution plans generated and the trace file outputs.
Test was:
Create a 1,000,000 row...
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

October 31, 2009 at 11:08 am

#1073518
RE: Are the posted questions getting worse?

CirquedeSQLeil (10/29/2009)
How do you find the time? School, articles, SSC, writing books, work...
A former boss of mine used to say... if 24 hrs a day isn't enough, work nights.
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

October 29, 2009 at 7:23 pm

#1072923

Viewing 15 posts - 4,921 through 4,935 (of 5,588 total)