WayneS

Forum Replies Created

Viewing 15 posts - 4,846 through 4,860 (of 5,588 total)

RE: Universal date format for WHERE clauses.

Michael Valentine Jones (1/27/2010)
There are two datetime string formats that are interpreted correctly with with any language setting.
With the first format, only the YYYYMMDD part is required, but...
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 27, 2010 at 2:09 pm

#1109589
RE: Are the posted questions getting worse?

Lynn Pettis (1/27/2010)
Ray K (1/27/2010)
Just curious: is anyone else besides me struck by the number of people asking about character-to-date conversions?
See it quite often. Most replies are that it...
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 27, 2010 at 11:57 am

#1109495
RE: Time - Adding minutes and seconds

This should do the trick:
-- note how this starts off by creating a table structure and putting data into it?
-- In order to get people willing to help, this is...
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 27, 2010 at 11:25 am

#1109471
RE: Mishi Kobe Niku

jameslester78-958147 (1/21/2010)
Mishi Kobe Niku, what is it?
And all I could think of (all the while knowing it was wrong) was Star Trek, Capt. Kirk, and the no-win simulation he cheated...
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 26, 2010 at 2:22 pm

#1108953
RE: Log Shipping, Transaction Logs not being restored (error:14421)

I had a problem just like this... by any chance are these VMs? Was one a copy of the other? If so, you may need to adjust the entries in...
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 26, 2010 at 8:44 am

#1108730
RE: How to query on acedemic years?

I suggest a second table to hold the academic year and the starting date of that year. ie.
declare @AcademicYears TABLE (AcademicYear smallint PRIMARY KEY CLUSTERED, StartDate datetime)
insert into @AcademicYears
values (2010,...
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 25, 2010 at 9:55 pm

#1108480
RE: Declarative Data Integrity

Kelsey Thornton (1/25/2010)
bitbucket-25253 (1/25/2010)
<snip>
In the future I will when appropriate not copy a snippet of the explanation, but rather just post a link to the supporting documentation.
I think an appropriate...
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 25, 2010 at 2:58 pm

#1108415
RE: Urgent development question

CirquedeSQLeil (1/25/2010)
Here is a thread that may help you find your solution. You will still need to look at the code and determine how to adapt it to 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

January 25, 2010 at 2:33 pm

#1108402
RE: We'll go no more a' tibbling

GSquared (1/25/2010)
Grant Fritchey (1/25/2010)
I think a lot of this, for me anyway, is just habit. Is there a good reason any more to put idx or ix at the beginning...
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 25, 2010 at 2:15 pm

#1108388
RE: Are the posted questions getting worse?

Steve Jones - Editor (1/25/2010)
Looks like The Thread is alive and well. Good to be back and hoping everyone behaved over the last week.
Shoot, he's back early. quick, everyone clean...
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 25, 2010 at 8:56 am

#1108199
RE: Are the posted questions getting worse?

Alvin Ramard (1/23/2010)
WayneS (1/23/2010)
Well, USPS just delivered my "SQL SERVER MVP Deep Dives". After a quick scan through it, all I can say is WOW! All these MVPs did 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 24, 2010 at 7:39 pm

#1107983
RE: Declarative Data Integrity

The explanation, while by itself is accurate, in the context of this question does not really provide an adequate explanation.
A better explanation might be explaining how, with cascading deletes, how...
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 24, 2010 at 7:20 pm

#1107981
RE: Are the posted questions getting worse?

Well, USPS just delivered my "SQL SERVER MVP Deep Dives". After a quick scan through it, all I can say is WOW! All these MVPs did a great job!
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 23, 2010 at 1:40 pm

#1107816
RE: Are the posted questions getting worse?

P Jones (1/22/2010)
Then there is one application that uses MSDE... and they have it locked down so that we can't even access it to do anything...
Bet that's the dreaded...
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 23, 2010 at 1:19 pm

#1107812
RE: how many databases present in the sqlserver

sivark1 (1/21/2010)
Thank you very much for your replies but it is not working in sql 2000
Hmm, this IS a SQL 2008 forum that you posted in.....;-)
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 21, 2010 at 10:26 pm

#1107088

Viewing 15 posts - 4,846 through 4,860 (of 5,588 total)