WayneS

Forum Replies Created

Viewing 15 posts - 1,591 through 1,605 (of 5,588 total)

RE: Are the posted questions getting worse?

Craig Farrell (3/30/2011)
john.arnott (3/30/2011)
Kiara (3/29/2011)
I'm going to take a moment and thank you all yet again for help that you didn't know you just provided.
I just spent about 45 minutes...
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

March 30, 2011 at 10:37 pm

#1305779
RE: Are the posted questions getting worse?

GilaMonster (3/30/2011)
Stefan Krzywicki (3/30/2011)
GilaMonster (3/30/2011)
Craig Farrell (3/30/2011)
Grant Fritchey (3/30/2011)
GilaMonster (3/30/2011)
For your amusement, this (attached) was part of a project plan I received today, specifically the test plan....
And that blank spot...
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

March 30, 2011 at 10:36 pm

#1305778
RE: difference between standby and read-only

Thanks Jason - I was thinking that, and forgot to put it in there.
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

March 30, 2011 at 5:51 pm

#1305749
RE: Script to Return all User Tables, Including Column Names

You might want to consider adding the schema name to the query that Lutz posted:
SELECT s.name AS schema_name,
t.name AS table_name,
...
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

March 30, 2011 at 4:11 pm

#1305734
RE: difference between standby and read-only

A standby database is part of a high-availability set where the database can be brought on-line (relatively) quickly for use.
A read-only database is online, but you cannot perform any 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

March 30, 2011 at 4:03 pm

#1305733
RE: Parameterized Table-Valued Function VS. Parameterized Stored Procedure - Selecting and returning data by value(s)

Generally speaking, I would go with an iTVF.
For a stored procedure, if it needs to be called for every row in a query, then you have no choice but 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

March 30, 2011 at 4:00 pm

#1305731
RE: Log Shipping SQL2008R2 - SQL2008 SP1

GilaMonster (3/30/2011)
WayneS (3/30/2011)
Well, you MVPs need to stress to MS how confusing this R2 naming scheme is to everyone, and how they need to stop it.
You think it hasn't been...
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

March 30, 2011 at 3:54 pm

#1305728
RE: Log Shipping SQL2008R2 - SQL2008 SP1

Well, you MVPs need to stress to MS how confusing this R2 naming scheme is to everyone, and how they need to stop 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

March 30, 2011 at 12:38 pm

#1305620
RE: Are the posted questions getting worse?

Chad Crawford (3/30/2011)
Wahoo! After 4 months of wrangling, got the PASS Summit approved (and paid for) today!
Congrats! Hope I can make it also...
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

March 30, 2011 at 12:34 pm

#1305616
RE: Are the posted questions getting worse?

Fal (3/30/2011)
Only I can't take a chainsaw into the .Net developer meetings.
Hmm - this could help out quite a bit over here also! 😀
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

March 30, 2011 at 8:41 am

#1305471
RE: Are the posted questions getting worse?

Grant Fritchey (3/30/2011)
I'm going, but I'm working. I'll be doing a presentation as well as representing Red Gate (one of the sponsors) on the cruise.
If you can get me 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

March 30, 2011 at 6:46 am

#1305397
RE: Greetings from a new (future) SQL DBA.

steven.hulse (3/29/2011)
Thanks for the warm welcome guys! Even though i'm a little aprehensive about taking on this challenge, I am looking forward to it. I strangely found when working 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

March 29, 2011 at 4:03 pm

#1305186
RE: Need Some Help with Basics

LutzM (3/29/2011)
I know I have to practice my written English... But I don't want to use this specific thread... 😉
Well, you can always use The other Thread. 😀
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

March 29, 2011 at 11:36 am

#1305051
RE: Problem: how to realize custom order

Birby1974 (3/29/2011)
WayneS, your solution works fine for me 🙂
Thanks again.
Birby1974
Great, thanks for the feedback.
Now, please read the first line in my signature, and ask if you have any questions about...
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

March 29, 2011 at 10:52 am

#1305029
RE: Retrieving a parent attribute value based on its child

How's this?
;WITH cte AS
(
SELECT [parent] = d.v.value('../@name[1]', 'varchar(50)'),
[child] = d.v.value('@id[1]', 'varchar(50)')
FROM @myXML.nodes('/root/parent/item') AS d(v)
)
SELECT [parent]
FROM cte
WHERE child = '4'
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

March 29, 2011 at 8:50 am

#1304930

Viewing 15 posts - 1,591 through 1,605 (of 5,588 total)