Viewing 15 posts - 721 through 735 (of 3,011 total)
There are plenty of other places where bad data could cause problems. Many factories use computers to control processes, so bad data that caused a Bhopal like release of...
September 13, 2011 at 8:25 am
Space in tables and indexes is allocated to filegroups, so it there is no available space in a specific file group, then no data can be added, even if files...
September 13, 2011 at 7:45 am
If you are actually looking for minimum downtime, backup/restore and then apply diff or tran log backups is faster.
You can create the backups and restore them with NORECOVERY before you...
September 9, 2011 at 8:36 am
Usual warnings: Your mileage may vary. Test it yourself. Don't blame me if you hurt yourself.
I will say that I have yet to see a case where...
September 8, 2011 at 10:31 am
It does vary quite a bit. As an example, a Litespeed backup of a 350 GB database over the network to a NAS file share went from 4-5 hours...
September 8, 2011 at 10:13 am
GilaMonster (9/4/2011)
kp_kumar (9/4/2011)
You can reduce the backup time by specifying multiple files instead of single file.Only if those files are on separate drives (not separate partitions of one drive)
Actually,...
September 8, 2011 at 9:54 am
It would be better to leave the clustered index in place and load the table in sequence by the clustered index. This is usually faster than rebuilding the clustered...
September 8, 2011 at 9:40 am
From SQL Server 2008 Books Online:
"BACKUP (Transact-SQL)
...
MIRROR TO <backup_device> [ ,...n ]
Specifies a set of one or more backup devices that will mirror the backups devices specified in the...
September 6, 2011 at 5:04 pm
It would be simpler to use dynamic SQL and just construct the exact ORDER BY clause that you need.
August 31, 2011 at 12:46 pm
Rogman (8/30/2011)
August 30, 2011 at 3:53 pm
A CASE statement can only return a single datatype; it cannot return a varchar(25) on some rows and a BIGINT on other rows.
August 30, 2011 at 11:39 am
Peter Maloof (8/28/2011)
SwayneBell (8/24/2011)
Some years back, I was a regular contributor in Oracle forums and I can assure you that the "snarky-ness level" is much higher there.
Absolutely. It's my opinion...
August 30, 2011 at 11:28 am
sqlnaive (8/30/2011)
GSquared, I mentioned "In 2005, it was returing 1 while in 2008 the same value returned 0"
You said the exact opposite in your third post.
Can you please post the...
August 30, 2011 at 8:18 am
What is the output of these statements when you run them on each server?
select
DT1 = isdate('01/01/2011'),
DT2 = isdate('01-01-2011'),
SQLVersion = convert(varchar(20),serverproperty ('ProductVersion'))
dbcc useroptions with no_infomsgs
August 30, 2011 at 7:44 am
Even is the index data is completely cached in memory (so that the disk is not involved at all) there is still a benefit because it uses less memory and...
August 29, 2011 at 11:14 am
Viewing 15 posts - 721 through 735 (of 3,011 total)