WayneS

Forum Replies Created

Viewing 15 posts - 4,111 through 4,125 (of 5,588 total)

RE: Memorial Day 2010

To anyone that has ever served in any branch of the military, I say:
Thank you for your sacrifice and service!
I also thank your family for their sacrifice.
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

May 29, 2010 at 8:46 pm

#1174283
RE: Auto Increment Alphabet

ColdCoffee (5/28/2010)
A slight modification on WayneS' code is producing exact simliar test timings as mine
...
@Wayne Shef, mate, am not as experienced or as agile or as smart as u 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

May 28, 2010 at 8:25 pm

#1174202
RE: Auto Increment Alphabet

Ankit Mathur-481681 (5/27/2010)
But struggling to make it a dynamic option to go to AAA & once it reaches ZZZ to AAAA.
Thanks Wayne,
Your solution fits the bill till ZZZZ. I think...
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

May 28, 2010 at 8:17 pm

#1174201
RE: Setting a variable to an expression

In your script task, did you set the variable to be read/write?
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

May 28, 2010 at 8:11 pm

#1174200
RE: Query for concurrent users for a particular period.

David_W1234 (5/28/2010)
Thanks a lot hester84!! It works!!
However, if I would like it to show the number of max concurrent users per day for a month of April, how can...
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

May 28, 2010 at 8:02 pm

#1174197
RE: Best approach to execute this code

Question : What do I do to run the above aspnetdb exec on each line of the output, A While loop, Cursor, SELECT ???
A cursor is bad. A while loop...
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

May 28, 2010 at 7:25 pm

#1174194
RE: Insert/Update

itlk (5/28/2010)
Hi,
In a situation when I want the record to be Inserted if it is new and to be Updated if it is existing is it better to:
1/ try 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

May 28, 2010 at 7:01 pm

#1174193
RE: Are the posted questions getting worse?

GilaMonster (5/28/2010)
WayneS (5/28/2010)
GilaMonster (5/28/2010)
Apparently my going rate it too high. He did ask at least.
Seems extremely reasonable to me!
It was. I did the exchange rate calc in my head and...
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

May 28, 2010 at 3:00 pm

#1174148
RE: What is your opinion on Outsourcing?

WayneS (5/28/2010)
TravisDBA (5/28/2010)
I started this topic in another thread and decided to move it over here.
Do you have a link to that other thread? I couldn't find it... 🙁
And 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

May 28, 2010 at 2:16 pm

#1174129
RE: Import and Export

passivebyz (5/28/2010)
So Import/Export is NOT meant for this kind of data refresh right?
Not really.
Something to note: log shipping leaves the backup server in a read-only state. And if not set...
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

May 28, 2010 at 2:09 pm

#1174124
RE: What is your opinion on Outsourcing?

TravisDBA (5/28/2010)
I started this topic in another thread and decided to move it over here.
Do you have a link to that other thread? I couldn't find 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

May 28, 2010 at 2:03 pm

#1174120
RE: Simple scalar function slows down query

Lynn Pettis (5/28/2010)
Here is a good blog post (if I do say so myself) regarding performance between inline code, inline TVF's, and scalar functions:
Comparing Hardcoded functions, In-Line TVF's, and Scalar...
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

May 28, 2010 at 1:58 pm

#1174118
RE: Are the posted questions getting worse?

GilaMonster (5/28/2010)
Lynn Pettis (5/27/2010)
GilaMonster (5/27/2010)
More free consulting? http://www.sqlservercentral.com/Forums/Topic928775-149-1.aspx
Anyone keen and free?
I don't mind deadlock questions (though they're often a fair bit of work), but this looks like a general 'look...
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

May 28, 2010 at 1:11 pm

#1174103
RE: Are the posted questions getting worse?

@Lynn - I was wondering how you were going to answer this one - you did a superb 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

May 28, 2010 at 1:08 pm

#1174102
RE: Inserting data to column having smalldatetime dataype

Because you're trying to do it as an integer...
You need to convert put it in a string to convert it to smalldatetime. Try:
set MyField = convert(char(8), 19000101)
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

May 28, 2010 at 11:21 am

#1174071

Viewing 15 posts - 4,111 through 4,125 (of 5,588 total)