WayneS

Forum Replies Created

Viewing 15 posts - 196 through 210 (of 5,588 total)

RE: Update table based on existing values in multiple rows

For the given data in MockTable, what are the expected results?
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

October 1, 2015 at 4:08 pm

#1830928
RE: ANY EASY WAY TO REDUCE THE CODE??

The quickest, most sure-fire way to reduce the code would be to use CTRL+A followed by CTRL+X. :w00t::w00t:
How about this for the first query?
DECLARE @NewCreditScores TABLE (insuredID INTEGER, creditScore INTEGER);
INSERT...
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

October 1, 2015 at 3:41 pm

#1830925
RE: Syntax help needed - how to find the index defs

The STATS_DATE() function may be able to help you narrow it down... unless you rebuilt all your indexes since you added the index, or if stats have been automatically updated.
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

October 1, 2015 at 3:23 pm

#1830920
RE: Are the posted questions getting worse?

Grant Fritchey (10/1/2015)
Eirikur Eiriksson (10/1/2015)
ChrisM@Work (10/1/2015)
Oh, and maple beer - yuck.
This made me spill my ESB all over the Pub lunch
😎
However, Maple Whiskey... YUM! Specifically though, when you use 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

October 1, 2015 at 8:25 am

#1830791
RE: Are the posted questions getting worse?

Luis Cazares (9/30/2015)
ChrisM@Work (9/30/2015)
Brandie Tarvin (9/30/2015)
ChrisM@Work (9/30/2015)
An unsolicited email has just dropped into my Hotmail inbox from a recruitment agency touting a permy dev DBA role in Soho (London) paying...
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

September 30, 2015 at 12:02 pm

#1830543
RE: How to avoid using scalar User Defined Functions?

Kristen,
Yes, an inline table-valued function would be your desired usage for code reuse. However, as you pointed out, not having the function at all is even better - but that...
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

September 26, 2015 at 7:42 am

#1829699
RE: Conversion failed when converting the varchar value - Error

Kristen-173977 (9/25/2015)
WayneS (9/24/2015)
this won't work... you need the "." between the different parts of the fully qualified name.
O/P has
Set @Dbo= '.dbo.'
but I agree it would be better to have 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

September 25, 2015 at 9:28 pm

#1829674
RE: Conversion failed when converting the varchar value - Error

SQL_Kills (9/25/2015)
So with my current script that I have found what actually needs to be changed for it to work as not sure now?
Thanks
Did you see the part of 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

September 25, 2015 at 9:27 pm

#1829673
RE: Are the posted questions getting worse?

Sean Lange (9/25/2015)
Steve Jones - SSC Editor (9/25/2015)
jasona.work (9/25/2015)
I've been wanting to pile into that topic, but keep restraining myself...
Hmm. Maybe we need to Godwin that topic, and bring...
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

September 25, 2015 at 8:34 am

#1829492
RE: Are the posted questions getting worse?

Eirikur Eiriksson (9/25/2015)
SQLRNNR (9/23/2015)
Eirikur Eiriksson (9/23/2015)
WayneS (9/23/2015)
Eirikur Eiriksson (9/23/2015)
SQLRNNR (9/23/2015)
Eirikur Eiriksson (9/23/2015)
This made me giggle
*cough*:cool:
Come on Jason, don't be shy, pitch one of your good comments:-P in here, I've only...
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

September 25, 2015 at 8:31 am

#1829490
RE: Conversion failed when converting the varchar value - Error

SQL_Kills (9/24/2015)
Hi,
Thanks for the reply, I'm not sure what to change now on my script?
Thanks
Edit... whoops, this is wrong.
New attempt:
SELECT @CntNow = COUNT(*) FROM Adventures.dbo.tblLibrary
If the table that you...
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

September 24, 2015 at 2:19 pm

#1829323
RE: Does SQL Server 7.0 have the option of Full, Simple, Bulk Recovery models

No it doesn't.
But... check this out: http://www.sqlservercentral.com/Forums/Topic18211-24-1.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

September 24, 2015 at 2:14 pm

#1829320
RE: Problem in sorting by alphanumeric table column of NVARCHAR datatype.

ChrisM@Work (9/24/2015)
WayneS (9/24/2015)
SELECT activityName
FROM #Activities
CROSS APPLY (SELECT PATINDEX('[A-Z,a-z][0-9]%', activityName),
...
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

September 24, 2015 at 7:44 am

#1829145
RE: Commercial Software with All Tables as Heaps and Terrible Performance

robinwilson (9/23/2015)
READ_COMMITTED_SNAPSHOT
This option does look like a possible option and would seem better than the suggestion of using NO LOCK on everything. I have read up on this and can't...
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

September 24, 2015 at 7:35 am

#1829141
RE: Problem in sorting by alphanumeric table column of NVARCHAR datatype.

SELECT activityName
FROM #Activities
CROSS APPLY (SELECT PATINDEX('[A-Z,a-z][0-9]%', activityName),
...
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

September 24, 2015 at 7:28 am

#1829139

Viewing 15 posts - 196 through 210 (of 5,588 total)