Viewing 15 posts - 706 through 720 (of 921 total)
quote:
I stick by what I said...Per BOL (Administering SQL Server, Backup and Restore Operations, Transaction Log Backups):
The section on Restoring Transaction Log...
October 16, 2003 at 8:53 am
quote:
At that point you're at 17 bytes per ID compared to 16 for a GUID. Good alternative though. And I suppose that...
October 16, 2003 at 8:00 am
quote:
Can anyone verify whether the following is correct:Full backups are restored completely. So you can restore your 10/8/2003 full backup which...
October 16, 2003 at 6:49 am
Well, I doubt you'll run out of values if you do something like this:
CREATE TABLE Biggie(
Id dec(38,0) IDENTITY(-99999999999999999999999999999999999999,1))
--Jonathan
October 16, 2003 at 5:49 am
quote:
quote:
SELECT FName, LName, Hire_Date
FROM Employee
WHERE DATEDIFF(dd,GETDATE(),DATEADD(yy,DATEDIFF(yy,Hire_Date,GETDATE()),Hire_Date)) BETWEEN 0 AND 30--Jonathan
October 16, 2003 at 5:14 am
quote:
In what circumstance would you set your Win2k server to 'Use Windows NT Fiber'?
More than...
October 15, 2003 at 8:25 am
SELECT FName, LName, Hire_Date
FROM Employee
WHERE DATEDIFF(dd,GETDATE(),DATEADD(yy,DATEDIFF(yy,Hire_Date,GETDATE()),Hire_Date)) BETWEEN 0 AND 30
--Jonathan
October 15, 2003 at 6:44 am
quote:
I put this in and it returns 9 rows. Is this right? It seems to be for me! But...
October 13, 2003 at 4:06 pm
quote:
Sorry guys, I mean't one column, not one row. I can do this, but the overhead and risk is not really worth...
October 13, 2003 at 2:47 pm
Perhaps you are looking for the COUNT(DISTINCT ColumnName) aggregate function? Or just use the primary key of the members table with a self-join, e.g.:
SELECT COUNT(m.PKCol)
FROM...
October 13, 2003 at 5:47 am
quote:
Thanks Jonathan.I actually never thought that 4d4 would evaluate to a number. For me, '4d4' evaluates to only 4. Totally...
October 10, 2003 at 7:58 pm
SQL Server is able to evaluate that as a number, as it can use 4D4 (synonym, for some reason, of 4E4, AKA 4E+4 or 4*10^4) as a number. Try...
October 10, 2003 at 7:31 pm
Put the database in single-user and then run the repair:
EXEC sp_dboption 'DBName','single user','true'
DBCC CHECKTABLE ('sysindexes',REPAIR_REBUILD)
If this doesn't fix the problem, you may...
October 10, 2003 at 6:56 pm
Viewing 15 posts - 706 through 720 (of 921 total)