Viewing 15 posts - 436 through 450 (of 8,416 total)
jflynn-735049 (6/4/2012)
So it would just be ALTER INDEX [IX_tblUsersName] ON [dbo].[tblUsersName] REBUILD
The point opc.three was making is that you don't need to rebuild the index just to change this setting....
June 4, 2012 at 8:59 pm
Jeff Moden (6/4/2012)
I had considered it only so briefly because it's about 8 times slower than the traditional NEWID() method...
Well sure, but (a) I was just making sure you were...
June 4, 2012 at 8:32 pm
opc.three (6/4/2012)
June 4, 2012 at 6:32 pm
Jeff Moden (6/4/2012)
June 4, 2012 at 6:03 pm
SQLKnowItAll (6/4/2012)
You could always upgrade to 2012 and use one of the new window functions 🙂
Just don't assume they will always be 'better':
http://sqlblog.com/blogs/michael_zilberstein/archive/2012/03/14/42332.aspx
June 4, 2012 at 5:30 pm
opc.three (6/4/2012)
SQL Kiwi (5/30/2012)
...you should try to specify date/time literals using an international unambiguous format like '2011-12-02 10:52:00' instead of 'Dec 2 2011 10:52AM'.
I recently saw this on another...
June 4, 2012 at 5:27 pm
CELKO (6/3/2012)
I have a two part article on VIEWs in Simple Talk that might help.
Links:
http://www.simple-talk.com/sql/learn-sql-server/sql-view-basics/
http://www.simple-talk.com/sql/t-sql-programming/sql-view-beyond-the-basics/
June 4, 2012 at 12:01 am
...though it's not clear why we wouldn't just use the built-in RAND() instead:
IF OBJECT_ID(N'tempdb..#Proof1', N'U')
IS NOT NULL
DROP TABLE #Proof1;
GO
CREATE...
June 3, 2012 at 5:53 pm
CELKO (6/3/2012)
This is called an additive congruency generator, as opposed to a random number generator.
There are also Linear Conguential Generators, described as "...one of the oldest and best-known pseudorandom number...
June 3, 2012 at 4:27 pm
Matt Miller (#4) (6/1/2012)
A common stumbling block is to think there is some physical order to the table (there isn't).
Of course there is. You just can't depend on results...
June 1, 2012 at 9:29 pm
steviemoxford (5/31/2012)
June 1, 2012 at 9:07 pm
Maxer (6/1/2012)
June 1, 2012 at 8:06 pm
chrisph (6/1/2012)
I'm looking for an easy way to rollback databases for our development environment.
Another option (Enterprise/Developer Edition) is to create a snapshot database and restore to that. As always,...
June 1, 2012 at 7:55 pm
Updated recursive solution:
WITH LastNSF AS
(
-- Last NSF per account
SELECT
nsf.ACCT_NUM,
...
June 1, 2012 at 1:03 am
Lynn Pettis (5/31/2012)
Wait, you all are getting paid???? Hey, Steve .........
Well this is awkward :laugh:
May 31, 2012 at 10:29 am
Viewing 15 posts - 436 through 450 (of 8,416 total)