Viewing 15 posts - 496 through 510 (of 646 total)
Steve Jones (7/17/2012)
CONVERT still has crazy numeric codes for conversion. Wouldn’t it make more sense to do this:
DECLARE @dt datetime
SELECT @dt = GETDATE()
SELECT CONVERT( datetime, @dt, 'dd.mm.yy')
Hey Steve. Yes,...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
July 17, 2012 at 7:39 am
Dissension / opposition within groups is necessary to ensure a better decision or plan. I remember learning in college about the role of the "central negative" in a group and...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
June 5, 2012 at 6:11 am
This is a very awesome option. And it seems that Amazon is making it really easy to have a no-cost development DB server via this offer:
http://aws.amazon.com/rds/sqlserver/free/
Of course, that is for...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
June 4, 2012 at 10:05 pm
GSquared (5/30/2012)
Doctor Who 2 (5/29/2012)
So, how does one go about finding a better experience at job hunting, with solid companies that have more to offer than a pay check?
In terms...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
May 30, 2012 at 7:56 am
I definitely agree with the "mutual meeting" idea. Employment is a relationship, much like family, friendship, marriage, business/customer, etc. It is a two-way street having responsibilities, expectations, rights, give and...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
May 29, 2012 at 10:37 pm
mark hutchinson (5/17/2012)
1. generally, you will find that 500-1000 rows/transaction will give the optimal performance. Beyond that, you won't see much performance improvement.
Hi Mark and thanks for the reply.
I...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
May 28, 2012 at 10:24 pm
Cadavre (5/10/2012)
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
May 13, 2012 at 4:25 pm
Cadavre (5/9/2012)
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
May 9, 2012 at 4:07 pm
To Cadavre:
I do not dispute your results, but I will dispute your test itself on the grounds that it is not relevant to a situation where someone should or would...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
May 9, 2012 at 8:52 am
williams.frd (5/8/2012)
Am I out of line in thinking this is something that should be handled in a high-level object-oriented language?
Hello. I am going to say "yes", but I am not...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
May 8, 2012 at 8:40 am
Jeffrey Bijkerk (5/8/2012)
If you use regex combined with a where clause it can not use the index anymore. I think this is very important.
Hi Jeffrey. It is important to a...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
May 8, 2012 at 8:27 am
To david.rowland and Jeff Moden:
With regards to performance, whether compared to LIKE / PATINDEX or even a custom SQLCLR function, please keep in mind that the main "win" here for...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
May 8, 2012 at 7:40 am
chrisn-585491 (3/18/2012)
Given the many CTPs and RC0, it doesn't make much sense anymore to wait. Yes, there will be bugs but that doesn't set it apart from any other software....
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
March 18, 2012 at 1:41 pm
Years ago it did make sense to wait for SP1, but those days have been over for at least 7 years now.
I work at a company that was on SQL...
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
March 17, 2012 at 8:51 am
Perry Whittle (2/10/2012)
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
February 11, 2012 at 3:17 pm
Viewing 15 posts - 496 through 510 (of 646 total)