Viewing 15 posts - 481 through 495 (of 708 total)
If you wish to use snapshots, but be able to change the data displayed in the report, then use Filters.
Parameters are applied before the data is stored in...
October 1, 2007 at 6:53 pm
Databases upgraded from SQL Server 2000 to SQL Server 2005 will remain in SQL 2000 compatibility mode (mode 80). To switch the compatibility mode to SQL 2005 (level 90),...
October 1, 2007 at 6:32 pm
Contradicting an earlier post, PolyServe has nothing to do with load balancing. It's just a different kind of clustering (shared everything vs. shared nothing).
September 25, 2007 at 11:31 am
This sort of situation is where the windowed functions get really handy. In this case, I'm referring to the RANK() function. Rank calculates a 1..N value for sets of rows...
September 23, 2007 at 4:42 pm
A good technical interviewer (who's doing more than simply validating you told the truth on your resume) will *always* go over your head, in several directions outside of the job...
September 11, 2007 at 10:06 pm
try this instead: ...values (19,'2005/12/05') (note the single-quotes around the date)
Without quotes, SQL Server sees 2005/12/05 as 2005 ÷ 12 ÷ 5, which rounds to the...
September 8, 2007 at 11:14 am
Our application does over 200 million inserts a day, and we use a 15-minute log backup frequency. Your thoughts - better recoverability and quicker backups vs. taking fewer log backups...
September 8, 2007 at 10:29 am
I have heard a number of (non-American) folks who refer to taking an exam as 'writing' the exam. The OP was merely asking about getting started.
Karthikeyan: you can get started...
September 2, 2007 at 10:59 pm
Add a HOLDLOCK hint to retain the read locks through the transaction:
BEGIN TRANSACTION
SELECT ...
FROM t1 WITH(TABLOCKX, HOLDLOCK)
-Eddie
August 24, 2007 at 5:57 am
> I believe the "!=" operator has been deprecated and will fail to work in either 2005 or 2008, whereas ANSI standards generally will work as documented.
> Besides...
August 17, 2007 at 9:10 pm
Vista is a desktop OS. SQL 2005 Enterprise Edition performs an installation check to prevent installation on desktops and only install on servers. While I personally have not tried to...
August 15, 2007 at 7:35 pm
SELECT
Type, AAA, A, BBB, OTHER, (AAA...
August 9, 2007 at 4:01 pm
Your first question should have been answered by your restore testing. You are restore-testing your backups, right?
Restore a snapshot, and start applying logs through an NTBACKUP time.
The quality of...
July 14, 2007 at 12:57 pm
Did you try creating an http endpoint? (a.k.a. 'web service')
CREATE ENDPOINT [name] AS HTTP(PATH = 'virtual directory name', ....
This is monumentally easier than doing it in SQL 2000, can be...
July 9, 2007 at 6:45 pm
That CompanyID makes a terrific partitioning column.
-Eddie
July 4, 2007 at 10:45 am
Viewing 15 posts - 481 through 495 (of 708 total)