Viewing 15 posts - 11,581 through 11,595 (of 26,486 total)
Steve Jones - SSC Editor (5/31/2012)
In addition to Sean and Lynn's advice, buy a book. Work through it page by page. You'll learn a lot.
Building on this, go to a...
May 31, 2012 at 4:08 pm
joshd 1807 (5/31/2012)
Unfortunately the query doesn't...
May 31, 2012 at 4:00 pm
All I can say is that you have been fortunate until now. SQL does not guarantee order of data when you query a table without using an ORDER BY...
May 31, 2012 at 3:39 pm
The only way to ensure order is to use an order by clause. This may mean you need to add an identity column to the tables to ensure that...
May 31, 2012 at 3:29 pm
SQLKnowItAll (5/31/2012)
Well... As a final update I have found that it will in fact be removed later on an MS site.
Do you have a link to this info?
May 31, 2012 at 3:19 pm
ScottPletcher (5/31/2012)
An occassional highly unusual exception doesn't validate the horrible idea in general of identity as the default for a clus key.
Nevermind, we aren't going anywhere and doing it really...
May 31, 2012 at 2:33 pm
ScottPletcher (5/31/2012)
you could potentially have a very large and active table that is in a database mirrored over a slow wan connection.
If you're trying to...
May 31, 2012 at 2:24 pm
There may be architectual reasons for using an identity column for the clustered index. For instance, you could potentially have a very large and active table that is in...
May 31, 2012 at 2:11 pm
ScottPletcher (5/31/2012)
May 31, 2012 at 1:59 pm
ScottPletcher (5/31/2012)
While I may agree, I have to play devils advocate, why not cluster on the identity column?
Because the overwhelming majority of queries will specify the datetime.
I wish I had...
May 31, 2012 at 1:53 pm
And if you really want to learn, cough up the $50 or so and buy the Developers Edition. That will give you everything and you'll just be scratching the...
May 31, 2012 at 1:50 pm
ScottPletcher (5/31/2012)
May 31, 2012 at 1:40 pm
Sean Lange (5/31/2012)
Lynn Pettis (5/31/2012)
May 31, 2012 at 1:23 pm
Stefan Krzywicki (5/31/2012)
X, Y, Z, _
and SQL Server alphabetizes as
_, A, B, C
When every table...
May 31, 2012 at 1:20 pm
If you are logging successful logins, you should be able to use the default trace and/or errorlog to track who is logging in and running jobs.
May 31, 2012 at 1:18 pm
Viewing 15 posts - 11,581 through 11,595 (of 26,486 total)