WayneS

Forum Replies Created

Viewing 15 posts - 1,966 through 1,980 (of 5,588 total)

RE: please help very urgent

Forget SSIS. Tell your boss that the easiest way to set up an automatic failover is to have a witness server. It can even be the FREE edition of SQL...
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

January 6, 2011 at 8:42 pm

#1270394
RE: Are the posted questions getting worse?

Did anyone hear about Microsoft's Hotmail SQL Server cloud issue?
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

January 6, 2011 at 1:58 pm

#1270323
RE: unique Index for existing table with duplicates

Well, you have to get rid of the duplicates before doing the unique index. Here's how I'd do it:
WITH CTE AS(
SELECT [GuestID], [FirstName], [LastName], [BookDate],
...
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

January 6, 2011 at 12:47 pm

#1270300
RE: Do you use Facebook?

Steve Jones - SSC Editor (1/6/2011)
WayneS (1/6/2011)
ALZDBA (1/6/2011)
I polled for the third option 😛
I guess I hit enter... I've PM'd Steve to see if he can take it out, 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

January 6, 2011 at 12:22 pm

#1270284
RE: Convert Comma Separated Values into Rows

You're welcome. Do you understand it? (See the note in my signature...)
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

January 6, 2011 at 12:17 pm

#1270281
RE: Line of Code Explanation

I'm glad I didn't stir up the mud in the water!
Now... do you need help in getting rid of that c.u.r.s.o.r.?
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

January 6, 2011 at 12:10 pm

#1270271
RE: Convert Comma Separated Values into Rows

The ~~attached~~ below code produces your desired results. ~~(having trouble posting code directly from work - I'll move it into the post tonight!)~~
-- See how this starts off with a...
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

January 6, 2011 at 10:52 am

#1270211
RE: Convert Comma Separated Values into Rows

The DelimitedSplit8K function (Click here for the latest Delimited Split Function) will do this for you. It is probably the absolute fastest method that you'll find for splitting strings.
I have...
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

January 6, 2011 at 10:45 am

#1270204
RE: Convert Comma Separated Values into Rows

Just to make sure I understand, since ID 1 has "data2" in both rows, you want it returned only for the first row, and you want all the data ordered...
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

January 6, 2011 at 10:39 am

#1270201
RE: Are the posted questions getting worse?

jcrawf02 (1/6/2011)
WayneS (1/6/2011)
Edit3: I'd like to go, if for no other reason than to hang out with Brent and Tim for a week and to be able to absorb anything...
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

January 6, 2011 at 10:11 am

#1270190
RE: Are the posted questions getting worse?

Brandie Tarvin (1/6/2011)
WayneS (1/6/2011)
Brandie Tarvin (1/5/2011)
EDIT: Of course, the only reason I want to go on this cruise is for the Cruisiness of it (Caymans, Mexico). The SQL Classes themselves...
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

January 6, 2011 at 9:27 am

#1270174
RE: Is there a way to do this without a cursor/loop to process individual records?

Chad Carter (1/6/2011)
The most I have seen at one time is a couple of hundred records so we should be OK. I will begin testing with it and getting...
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

January 6, 2011 at 9:18 am

#1270168
RE: Line of Code Explanation

SQL_Dba_WannaBe (1/6/2011)
Hey group,
I was reviewing a CURSOR created and ran across a line of code that makes no sense to me. I was hoping someone out there could...
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

January 6, 2011 at 9:12 am

#1270165
RE: Multiple Constraints(FKs) Defined for the Same Relationship

Grant Fritchey (1/6/2011)
On the other hand, if it's Col1 to Col1, five times, no, that's useless, unnecessary and probably slows things down.
Yep, each FK would have to be validated 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

January 6, 2011 at 9:02 am

#1270159
RE: Do you use Facebook?

ALZDBA (1/6/2011)
I polled for the third option 😛
I guess I hit enter... I've PM'd Steve to see if he can take it out, all I can do is edit 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

January 6, 2011 at 8:58 am

#1270156

Viewing 15 posts - 1,966 through 1,980 (of 5,588 total)