Viewing 15 posts - 2,116 through 2,130 (of 3,011 total)
There really is no self-documenting code. Looking at the code only tells you what it actually does, not what it was meant to do. At the very least,...
January 5, 2009 at 9:01 am
This thread is amazing; there hasn’t been an on-topic post since Sunday but it just keeps on going. :exclamationmark:
January 1, 2009 at 10:06 am
A better backup strategy would be to eliminate the differential backups and run transaction log backups every 15 minutes 24x7. This will prevent your transaction log file from growing...
January 1, 2009 at 9:59 am
How about stupid date queries like this:
where Convert(varchar, CreationDate, 101) between Convert(datetime,@FromDate, 101) And Convert(datetime, @ToDate, 101)
which can amount to something like this:
where '12/30/2008' between '12/25/2008' And '01/05/2009'
December 31, 2008 at 4:06 pm
How about having some non-work related books so your new co-workers don’t think you’re a total dork?
Leave out a copy of “The Prince” by Niccolo Machiavelli so they’ll think you’re...
December 30, 2008 at 10:32 pm
What you describe is completely normal behavior for SQL Server. When SQL Server allocates memory, it does not give it back unless there is pressure from the OS.
Why are...
December 30, 2008 at 2:11 pm
RBarryYoung (12/30/2008)
The Scalable Shared Database feature enables you to scale out a read-only database built exclusively for reporting (a reporting database). The reporting database must reside on...
December 30, 2008 at 1:30 pm
sheppc1214 (12/30/2008)
Can someone provide information about "a shared scaleable database"?
Sounds like marketing BS.
A database has to be "shared", or it wouldn't really be much of a database.
As for "scaleable", is...
December 30, 2008 at 1:08 pm
Jeff Moden (12/29/2008)
The cast to VarBinary takes more time, Michael. That's the way I used to do it before Peter Larson and Matt Miller showed me this other way.
I...
December 30, 2008 at 8:48 am
Here is one more method to generate a random number in the range of 100000 to 999999.
It uses the right 7 bytes of the newid() to create a bigint value....
December 29, 2008 at 10:25 pm
That script does not generate a primary key value.
All is does is create a primary key on an existing table.
December 29, 2008 at 5:58 pm
Someone mentioned that you might gain some performance because the OS is accessing two files in parallel, instead of one. However, there is nothing that prevents you from having...
December 29, 2008 at 3:38 pm
Only extended stored procedures can be called inside a function.
December 26, 2008 at 7:37 am
There are a number of commercial utilities that let you produce compressed SQL Server backups:
SQL LiteSpeed, Redgate Backup, Idera has one, and there are several others.
Another option might be to...
December 24, 2008 at 12:54 pm
GilaMonster (12/24/2008)
Michael Earl (12/24/2008)
At least they were able to open Management Studio and run the query.
Well there was this one guy (who claimed to be a performance tuning guru and...
December 24, 2008 at 9:29 am
Viewing 15 posts - 2,116 through 2,130 (of 3,011 total)