WayneS

Forum Replies Created

Viewing 15 posts - 2,791 through 2,805 (of 5,588 total)

RE: Finding Sequences (Need help ASAP)

Paul White NZ (10/17/2010)
The SQLCLR test results are in:
Craig's test data (267,150 rows): 360ms
Jeff's test data (889,892 rows): 1386ms
Test rig and csv data for both runs attached, along with C#...
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 17, 2010 at 11:04 am

#1238133
RE: date manipulation

b?
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 17, 2010 at 10:55 am

#1238130
RE: Are the posted questions getting worse?

GilaMonster (10/17/2010)
Lennie's back...
(After reading past posts)... Ohhh, that Lennie
May I suggest that everyone just ignores that? I don't think we need another flaming thread here.
Ignored
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 17, 2010 at 10:50 am

#1238127
RE: Are the posted questions getting worse?

Alvin Ramard (10/17/2010)
GilaMonster (10/17/2010)
Lennie's back... http://www.sqlservercentral.com/Forums/Topic1005823-169-1.aspx
With some sample code that looks like an interesting cross between T-SQL and an object-orientated language.
SELECT .... WHERE OrderDate.Month = 2
May I suggest that everyone...
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 17, 2010 at 10:46 am

#1238125
RE: GUID clustered indexes vs. RID

I just read through this thread, and what I found interesting was what was missing (or, I just failed to see it...)
The keys in a clustered index are used 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

October 16, 2010 at 12:20 pm

#1238046
RE: errors found by DBCC CHECKDB

When composing your post, look below, in the "Post Options" section. There is a section titled "Attachments", with a button on the right that says "Edit Attachments". Click that button....
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 16, 2010 at 10:16 am

#1238039
RE: Are the posted questions getting worse?

GilaMonster (10/16/2010)
Is anyone willing to bet some money on whether he has a clean backup or not?
I'll bet... that he doesn'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

October 16, 2010 at 10:06 am

#1238034
RE: Are the posted questions getting worse?

GilaMonster (10/16/2010)
Swap? http://www.sqlservercentral.com/Forums/Topic1005710-265-1.aspx
Me: Run CheckDB and and post the full and unedited results
OP: I have used that command and it returned about 3000 line of error code. This is last...
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 16, 2010 at 9:56 am

#1238031
RE: sequence company code dependent through insert triggers

What college and professor gave you this homework assignment?
Why did you try to obscure your homework assignment by posting this as a company/account 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

October 16, 2010 at 9:25 am

#1238028
RE: Are the posted questions getting worse?

I just love these!
"I've got this task, needs to be done in an insert trigger".
So, I give the code for doing so.
"Now, can you incorporated it into my already...
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 16, 2010 at 9:20 am

#1238026
RE: Learning Oracle

Lynn Pettis (10/15/2010)
PaulB-TheOneAndOnly (10/15/2010)
nick.mcdermaid (10/14/2010)
I'm impressed with Oracle packages as they almost seem like classes to me
-Variables which 'reflect' existing table meta data
-Custom data types
-Multiple 'methods' within the package 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

October 16, 2010 at 7:00 am

#1237994
RE: Invalid Object Name

In SSMS, select Edit | Intellisense | Refresh Local Cache
Apparently, you built the function after opening the query window.
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 16, 2010 at 6:58 am

#1237993
RE: Count Row

Dehqon D. (10/16/2010)
Hi Forum,
I've to tables with one-to-many relationships (T1 and N2)
Current queries giving me different results which is making me confuse.
select COUNT(*) from N2
Result:122263
There are 122263 records...
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 16, 2010 at 6:55 am

#1237990
RE: Compound interest query

LutzM (10/16/2010)
I would use the "quirky update" method.
Disclaimer:
DO NOT USE the code
until you've read Jeff's article[/url] and the related discussion.
DO NOT USE the code
until...
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 16, 2010 at 5:49 am

#1237984
RE: Compound interest query

LutzM (10/16/2010)
I would use the "quirky update" method.
Disclaimer:
DO NOT USE the code
until you've read Jeff's article[/url] and the related discussion.
DO NOT USE the code
until...
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 16, 2010 at 5:47 am

#1237983

Viewing 15 posts - 2,791 through 2,805 (of 5,588 total)