Viewing 15 posts - 1,951 through 1,965 (of 7,498 total)
Keep in mind your hashes may produce duplicates as well !
June 18, 2011 at 7:31 am
Roy Ernest (6/17/2011)
GilaMonster (6/17/2011)
June 18, 2011 at 7:23 am
why aren't you just making that column an identity column.
alter table x
alter column seqnr bigint identity( yourstartvalue, yourincrementvalue ) ;
Keep in mind, you should no longer insert that column !...
June 18, 2011 at 2:04 am
June 17, 2011 at 10:12 am
WayneS (6/16/2011)
Roy Ernest (6/16/2011)
June 17, 2011 at 6:43 am
RedGate also has a nice free ebook on statistics.
http://www.red-gate.com/products/dba/sql-monitor/entrypage/statistics-ebook
June 17, 2011 at 4:59 am
How about this:
Select ITEMNMBR
, ROW_NUMBER() over (order by (select 1)) * 16384 as SeqNumbr
from IV00101
where ITEMNMBR not in...
June 16, 2011 at 11:49 pm
Nice overview !
I always keep in mind this very to the point article by Brent Ozar (@BrentO) regarding our job and virtualization:
http://www.theinfoboom.com/articles/virtualizing-databases-too-big-to-fail/
Pay special attention on the real question !
June 16, 2011 at 6:36 am
opc.three (6/15/2011)
How does one get the engine to store -0.00 ?
I tried:
USE test
GO
IF EXISTS ( SELECT *
...
June 15, 2011 at 2:10 pm
jcrawf02 (6/15/2011)
Last Saturday I attended my first SQL Sat in Columbus, and thoroughly enjoyed it. I had seen a tweet the day before in passing, where...
June 15, 2011 at 12:51 pm
Grant Fritchey (6/15/2011)
...
Nah, that's points. I was talking posts. I stopped getting points a while back. I just focus on the posts now. I just became #7 to cross the...
June 15, 2011 at 8:09 am
Please refer to Gails wonderful articles
- "Managing Transaction Logs": http://www.sqlservercentral.com/articles/64582/
and
- "Why is my transaction log full?" http://www.sqlservercentral.com/articles/Transaction+Log/72488/
June 15, 2011 at 7:59 am
Grant Fritchey (6/15/2011)
That's 10,000 posts, done.Wait, now it's 10,001.
Congratulations, Grant.
Apparently you have been very active today, now you're already at :
Points: 10,881, Visits: 21,283
June 15, 2011 at 7:02 am
If your db is using full ( or bulk ) recovery model, you can and should be making log backups !
There are 3th party tools like APEX log that can...
June 15, 2011 at 5:47 am
The picture use used in the editorial reminded me of the good old ROT13 solution on thread http://www.sqlservercentral.com/Forums/Topic579917-338-1.aspx some years ago. :w00t:
June 15, 2011 at 5:33 am
Viewing 15 posts - 1,951 through 1,965 (of 7,498 total)