Viewing 15 posts - 2,101 through 2,115 (of 5,590 total)
CirquedeSQLeil (12/16/2010)
Paul White NZ (12/16/2010)
WayneS (12/16/2010)
Here's just two of the reasons why I've turned it off:
I just typed this successfully in 2008 SSMS with Intellisense on (which it always is):
SELECT...
December 17, 2010 at 7:04 am
Chris Morris-439714 (12/17/2010)
Works for me too, but usually "SELECT TOP 10 * FROM", just a handy habit to get into.
Oh yeah: Even that causes a problem. I have a small...
December 17, 2010 at 6:56 am
hoanglong88i (12/16/2010)
DECLARE @tblTemp TABLE
(
...
December 16, 2010 at 9:23 pm
hoanglong88i (12/16/2010)
'row_number' is not a recognized function name.
Both my laptop and office's desk are...
December 16, 2010 at 9:18 pm
Paul White NZ (12/16/2010)
WayneS (12/16/2010)
Here's just two of the reasons why I've turned it off:
I just typed this successfully in 2008 SSMS with Intellisense on (which it always is):
SELECT ...
December 16, 2010 at 9:14 pm
Craig Farrell (12/16/2010)
Paul White NZ (12/16/2010)
CREATE TABLE dbo.Example
(
row_id INTEGER IDENTITY NOT NULL PRIMARY KEY CLUSTERED,
data ...
December 16, 2010 at 9:07 pm
Brandie Tarvin (12/16/2010)
Steve Jones - SSC Editor (12/16/2010)
December 16, 2010 at 6:53 pm
Using Kingston's fine sample code (hoanglong88i - please see the first link in my signature for how / why you need to do this), this seems to be producing the...
December 16, 2010 at 6:48 pm
Craig Farrell (12/16/2010)
WayneS (12/16/2010)
I can't believe that the "View is not ordered with an order by" thread is still going on. It's been thoroughly explained, and yet, still.....
Hehehe, and as...
December 16, 2010 at 6:01 pm
mister.magoo (12/16/2010)
WayneS (12/16/2010)
IMO, I see the "ordering being out of whack" for two reasons:1. An "ORDER BY" wasn't specified (duh), and
2. Parallelism (dual-core laptop here).
Agreed - I was ignoring the...
December 16, 2010 at 5:57 pm
Craig Farrell (12/16/2010)
WayneS (12/16/2010)
@craig-2 - what does this last select return on your system?
As expected, 5001-5005, 7001-7005, 9001-9005, and the final select starts at 1 and carries through (for about...
December 16, 2010 at 5:46 pm
mister.magoo (12/16/2010)
I wonder do you know is that behaviour dependent on it being a #temp table rather than a non-temp table...
December 16, 2010 at 5:42 pm
I didn't have to pay anything for it... when I clicked on a LiveMeeting link, it allowed me to just download it.
Contact Jason as to the date of the meeting....
December 16, 2010 at 5:25 pm
What are your preferences for VM machines - VMWare or VirtualPC?
I've been using VMWare for years (and am happy with it), but to install a 64-bit Windows 7 and Denali,...
December 16, 2010 at 5:06 pm
Viewing 15 posts - 2,101 through 2,115 (of 5,590 total)