WayneS

Forum Replies Created

Viewing 15 posts - 4,936 through 4,950 (of 5,588 total)

RE: Trying to UnPivot without using multiple selects unioned together

Bob Hovious 24601 (10/28/2009)
You're welcome, Wayne. Please let us know which you finally go with and why. If one is significantly faster than the other,...
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 28, 2009 at 6:09 pm

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

Hey guys, this looks awesome. I had pushed the UNPIVOT out of my mind 'cause I didn't think it would work with multiple sets of columns.
I'll post some results 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

October 28, 2009 at 7:05 am

#1071682
RE: The DBA Dilemma: How Many DBAs Does It Take to Manage an Infrastructure?

I assume you're counting a server as an instance of sql server? Thus one physical computer might have several sql servers?
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 27, 2009 at 6:05 am

#1071142
RE: Are the posted questions getting worse?

That's a bummer Jeff... but is the new job going good?
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 26, 2009 at 8:31 pm

#1071000
RE: Are the posted questions getting worse?

RBarryYoung (10/26/2009)
I've been through it twice before, so I know what I'm in for...
Sounds like it's not going to be easy, but I'll be praying for a speedy recovery.
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 26, 2009 at 8:29 pm

#1070999
RE: Are the posted questions getting worse?

Steve Jones - Editor (10/21/2009)
Database Pork Chops
---------------------
4 large chops, bone-in
cayenne pepper
flour
sharp knife
trebuchet
With the knife, sharpen the end of the bones until they achieve a dangerous point.
Liberally coat the chops with...
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 21, 2009 at 4:48 pm

#1069182
RE: Are the posted questions getting worse?

GabyYYZ (10/21/2009)
I've been wondering if people who accidentally stumble onto the first page of the THREAD and casually go from page to page, not realizing how long it has grown?...
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 21, 2009 at 4:42 pm

#1069179
RE: Are the posted questions getting worse?

Bob Hovious 24601 (10/20/2009)
I have this odd vision of one of the "outsourcees" bringing a problem here for assistance, and then Wayne helps him out and finally sees his own...
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 21, 2009 at 4:40 pm

#1069178
RE: Are the posted questions getting worse?

Paul White (10/21/2009)
Venting time. Feel free to skip this post if you're not in the mood to hear me whinge on... 🙂
So, this guy Steve McRoberts goes to all...
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 21, 2009 at 5:13 am

#1068768
RE: SSMS issue with solutions since the 10/14/2009 MS Updates

Jonathan Kehayias (10/20/2009)
Reapply Service Pack 1 to SSMS 2008. There is a DLL from 2005 that was reregistered during the updates that is causing the issue. Running SP1...
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 21, 2009 at 5:04 am

#1068762
RE: using store procedure to populate SSRS Parameters

adonismartinez (10/20/2009)
I have a store procedure that work fine for entire results, but I am interest it in populating my parameters with result of my store procedure, do I 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

October 20, 2009 at 1:49 pm

#1068492
RE: Are the posted questions getting worse?

Steve Jones - Editor (10/20/2009)
Good luck, Wayne. Remember, it's just a job.
Yeah, but at least I'm in the position where I can reject their code... they just keep coming 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

October 20, 2009 at 1:39 pm

#1068484
RE: Benefits of FULL Recovery model over SIMPLE (other than PIT recovery)?

On a related note, is there any benefit to having a database in either the Full or Bulk-Logged recovery model if log backups are not occurring?
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 20, 2009 at 12:04 pm

#1068415
RE: Are the posted questions getting worse?

bitbucket-25253 (10/20/2009)
WayneS
Just had a "developer" send me some code.
Wayne I submit that your problem is NOT with the developer but with either the hiring/current Manager who think that the individual...
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 20, 2009 at 11:13 am

#1068362
RE: Are the posted questions getting worse?

Jeff Moden (10/19/2009)
WayneS (10/19/2009)
Hey Jeff... can you FedEx me your biggest, baddest pork chop launcher? I think I'm in dire need of it.....
Just had a "developer" send me some code.
SP...
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 19, 2009 at 9:38 pm

#1067934

Viewing 15 posts - 4,936 through 4,950 (of 5,588 total)