WayneS

Forum Replies Created

Viewing 15 posts - 4,996 through 5,010 (of 5,588 total)

RE: SQL Server Developer Edition

and if you want it cheaper than $49, try here
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

August 17, 2009 at 5:26 pm

#1040581
RE: Consolidate on 64bit?

The biggest issue that I've seen with 64-bit hardware isn't with the database... that will work just fine. My problem has been with SSIS not having access to drivers 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

August 17, 2009 at 3:54 pm

#1040559
RE: Issue with assigning candidates to a review list

RBarryYoung (8/17/2009)
Thanks Wayne, Jeff.
I played around with it a little using what I felt was more naturally distributed data (making some schools much more popular than others) and it seems...
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

August 17, 2009 at 3:20 pm

#1040537
RE: COUNT

Just want to point out that you are using the BETWEEN operator with a date field... if your date field can have time values in it, then you probably are...
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

August 17, 2009 at 10:07 am

#1040320
RE: Issue with assigning candidates to a review list

Barry,
Nice... real nice. I like the approximate number calc, which was what I was missing.
I did run into one issue in implementing it... and it's my fault. The data...
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

August 17, 2009 at 9:32 am

#1040277
RE: Issue with assigning candidates to a review list

RBarryYoung (8/14/2009)
Jeff Moden (8/14/2009)
RBarryYoung (8/14/2009)
Wayne: Any chance we could get some Create Table defs & sample data Inserts?
See Paul's post... it's the same stuff as before (I think).
Oops, 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

August 15, 2009 at 8:17 am

#1039822
RE: Issue with assigning candidates to a review list

I've played around a bit with John's suggestion. I've come up with a cursor-based solution, but I can't figure out a set-based solution. I think the problem is that 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

August 12, 2009 at 1:20 pm

#1038240
RE: Issue with assigning candidates to a review list

john.arnott (8/10/2009)
If I understand this correctly, your final selection of three board members for a candidate could be the first three rows of an intermediate resut (one of your CTE's...
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

August 11, 2009 at 10:43 am

#1037591
RE: Are the posted questions getting worse?

Jeff Moden (7/30/2009)
Roy Ernest (7/29/2009)
Congratulations to Grant for winning the "Best Thing I Learned at PASS Summit" contest. 😀
What's the link?
http://summit2009.sqlpass.org/AboutSummit/ROI/BestThingWinners.aspx
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

July 30, 2009 at 9:30 pm

#1032775
RE: break down into hours, minutes and seconds

TAman (7/29/2009)
I'm not sure what you are representing when you say "stuff"("stuff"
And what does the '00000' represent?
Select *
,stuff(stuff(right('00000' + cast(TimeValue...
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

July 29, 2009 at 1:18 pm

#1031986
RE: View Deadlock Graphs

Hi Sam,
I wrote this script to run along with this one: http://www.sqlservercentral.com/scripts/deadlock/66808/
If you have an active deadlock server-side trace running that has the word "Deadlock" in the output file, then...
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

July 23, 2009 at 5:02 pm

#1029369
RE: View based off table Variable?

shannonjk (7/22/2009)
Hello everyone.
I have a bit of a challenge I am attempting to resolve but keep coming up at dead ends.
I have an Invoice table that once 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

July 22, 2009 at 5:31 pm

#1028719
RE: Multiple instances on a cluster?

Hi SqlBuddy,
But multiples instances on a single cluster node is not usually recommended.
Do you happen to have any microsoft (preferred, or any other) links / white papers saying this?...
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

July 21, 2009 at 5:22 am

#1027524
RE: Intersect, Except, Union, All and Any

Very good article David.
One area where I find INTERSECT / EXCEPT easier to work with is when dealing with multiple columns, such as what you might find for a 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

July 19, 2009 at 9:29 am

#1026638
RE: Having problem getting rid of index scan in procedure

Gianluca Sartori (7/17/2009)
I'm sorry, I was referring to the original post 'cause I had no time to look at the revised one. It's very strange: yesterday I removed from your...
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

July 17, 2009 at 11:03 am

#1026332

Viewing 15 posts - 4,996 through 5,010 (of 5,588 total)