Viewing 15 posts - 3,286 through 3,300 (of 8,416 total)
vk-kirov (5/26/2010)
Hmmm... Microsoft changed it in SQL Server 2008. In SQL 2005, 'DECLARE @b-2 sYsNaMe' produces an error. Well, SQL 2008 became more consistent here.
I didn't know that - I...
May 26, 2010 at 12:22 pm
Very nice question today. I only found it easy because I have been doing stuff with unusual collations recently.
There's a great set of visual tables showing sort (and comparison)...
May 26, 2010 at 12:10 pm
Hey James,
So:
"It is well know for instance that if we put NEWID() in a SELECT statement, it will be executed once per row. Other functions and expressions such...
May 26, 2010 at 11:17 am
Is the current column defined as NOT NULL? If so, there is a neat trick that makes it almost instant regardless of the number of rows.
Table definition please (including...
May 26, 2010 at 10:40 am
Gianluca Sartori (5/26/2010)
Steve Jones - Editor (5/26/2010)
no, there have been some doozy's this week. Though our PhD friend doesn't help the impression.Who? You mean this individual?
Karthik confuses me. Just...
May 26, 2010 at 10:26 am
Chris Morris-439714 (5/26/2010)
David Webb's is darned good too:David Webb-200187 (5/25/2010)
"I don't know why your update didn't work. Perhaps your data has trouble accepting change."
Sparkling.
May 26, 2010 at 10:25 am
vk-kirov (5/26/2010)
Paul White NZ (3/30/2010)
It seems odd to me that type names must be lower cased in a case-sensitive database.It's not true (or I don't understand what you mean).
I was...
May 26, 2010 at 9:16 am
David.Poole (5/26/2010)
What am I doing wrong Paul? I don't seem to get any space back (in SQL2005) other than that I would get by defragging the index.
What are you...
May 26, 2010 at 9:01 am
David,
I just scanned through on a first read, but something important caught my eye:
In the section on changing data types (after rebuilding the clustered index) you say that for SQL...
May 26, 2010 at 4:32 am
DECLARE @Parameter VARCHAR(MAX);
SET @Parameter = ',' + 'A123,B123,C123,D123,E123,F123' + ','
BEGIN TRANSACTION
-- Update existing items
UPDATE ReportData
SET -- New...
May 25, 2010 at 5:20 am
Thanks for the execution plan, shame about the table definition, sample data, and index definitions, but I'll take what I can get.
You might consider an index like the following:
CREATE ...
May 25, 2010 at 4:58 am
GilaMonster (5/25/2010)
Paul White NZ (5/25/2010)
Whatever figure you decide on, remember to send 80% of it to the people on here that have helped you over the last year 😀
Only the...
May 25, 2010 at 4:49 am
GilaMonster (5/25/2010)
Paul White NZ (5/25/2010)
It sucks a bit as a solution for reasons already given in this thread (not SARGable) but that doesn't stop people using it.
Also doesn't stop people...
May 25, 2010 at 4:47 am
karthikeyan-444867 (5/25/2010)
???
Not wasting any words tonight, are you? 😀
In a case sensitive collation 'a' <> 'A' so developers often throw a LOWER or UPPER on both sides to get around...
May 25, 2010 at 4:27 am
Viewing 15 posts - 3,286 through 3,300 (of 8,416 total)