Viewing 15 posts - 4,711 through 4,725 (of 5,588 total)
Chim Kalunta (2/23/2010)
inner join WhitePage w on w.displayname = a.displayname or w.eid = a.eid
is forcing a Clustered Index Scan on the Whitepage table. Thats where...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
February 25, 2010 at 8:21 am
GSquared (2/25/2010)
But I'm also one of those freaks who wants the US to switch to metric measures and 24-hour clocks and should get rid of daylight savings time.
You mean there's...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
February 25, 2010 at 8:06 am
Joy Smith San (2/25/2010)
Thought memory tables would be faster, hence used it.
You might want to check out this article[/url]
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
February 25, 2010 at 7:17 am
FYI, if your data would ALWAYS have 3 periods in there, you could use the ParseName function to return the position that you wanted.
i.e.:
DECLARE @x VARCHAR(80)
SET @x = '400.367.369.379'
select PARSENAME(@x,...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
February 25, 2010 at 7:10 am
Thanks for responding back on how you resolved it.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
February 25, 2010 at 7:09 am
Very good article Tim.
majorbloodnock (2/25/2010)
I'll also suggest a good rule of thumb (closely linked with Tim's point) is to criticise privately and congratulate publicly.
and might I add to the congratulate...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
February 25, 2010 at 7:02 am
reidres (2/24/2010)
...Gianluca's unpivot works for 1 000 000 rows only, no more or less. So it is not scalable nor flexible--and who only wants a million rows?
That would be...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
February 25, 2010 at 6:49 am
CirquedeSQLeil (2/24/2010)
WayneS (2/24/2010)
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
February 25, 2010 at 6:44 am
You will only need one of those where conditions, but you will need all 4 in the join between the tables. The query itself looks fine.
You should also test whether...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
February 25, 2010 at 5:09 am
FYI, Gianluca's unpivot works the fastest on my system (813ms), though Lynn's is right behind (833ms) - initial runs. But, when run repeatedly (and randomly), they actually flip-flop back and...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
February 24, 2010 at 9:15 pm
Tom, I think that the "<" and ">", when inside the sql code window, get converted into xml tags: "& lt;" and "& gt;" (without the spaces). I'll bet this...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
February 24, 2010 at 2:12 pm
Paul White (2/24/2010)
WayneS (2/24/2010)
Something that you're about to write an article on?Oh highly amusing, Wayne! :laugh:
But Paul.... I'm serious!
BTW, I know you've told me before how you get the...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
February 24, 2010 at 1:20 pm
ekant_alone (2/24/2010)
i am little curiouscan't we use 'year' function in where clause?
Yes, you can use it.
But let me show you why you shouldn't.
First, let's create a test table...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
February 24, 2010 at 1:02 pm
Use the OUTPUT clause on the UPDATE statement to return back the rows being updated.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
February 24, 2010 at 12:08 pm
The following code is another way of doing it.
You might want to look at the first link in my signature for better ways to post to make it easier for...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
February 24, 2010 at 12:04 pm
Viewing 15 posts - 4,711 through 4,725 (of 5,588 total)