Viewing 15 posts - 2,146 through 2,160 (of 2,904 total)
By the way, search this site...there's lots of information about DATETIME/SMALLDATETIME. The question you asked, probably gets asked once a week or so.
-SQLBill
March 31, 2004 at 1:58 pm
Just found this in "Inside Microsoft SQL Server 2000" by Kalen Delaney...
SELECT rows
FROM sysindexes
WHERE id=OBJECT_ID ('dbname')
AND indid < 2
This only works for base tables, not views and only if...
March 31, 2004 at 1:56 pm
How do you want to see the information?
You could use Enterprise Manager, expand down to the database, expand the database, click on Tables, and in the right pane, right click...
March 31, 2004 at 1:46 pm
Yes, with 0 or no number (DBCC SHRINKDATABASE mydatabase) will shrink the database to as small as it can get, but no smaller than what the mydatabase was set to...
March 31, 2004 at 1:42 pm
1. You CANNOT save just the date. DATETIME datatype is just that - both the date and time. It is really eight bytes; four bytes are the number of days...
March 31, 2004 at 11:09 am
Stacenic,
Definitely work up an article on that script. But until you do so, you might want to just submit your script as is.
-SQLBill
March 31, 2004 at 10:59 am
Check out DBCC SHRINKDATABASE in the Books OnLine.
-SQLBill
BOL=Books OnLine = Microsoft's SQL Server Help. Installed as part of the Client Tools. Found at Start>Programs>Microsoft SQL Server>Books OnLine or in Query...
March 31, 2004 at 10:56 am
Gary,
Just to let you know, approximately 200 GB took me just over 6 hours to restore.
Win2K Advanced Server, 4 Processor, SQL Server 2000.
-SQLBill
March 31, 2004 at 8:02 am
Two thoughts for you....
1. You could probably do the DBREINDEX on all tables using the undocumented stored procedure "sp_msforeachtable". But it might not be a 'wise' idea. DBREINDEX requires the...
March 31, 2004 at 7:50 am
Try this:
DECLARE @mystr VARCHAR(20)
SET @mystr = 'Bill Fleming 123'
SELECT SUBSTRING(@mystr,1,(PATINDEX('%[0-9]%', @mystr)-1)) AS [First part],
SUBSTRING(@mystr,(PATINDEX('%[0-9]%', @mystr)), LEN(@mystr)) AS [Second part]
I tested this and typed it up just before the end of...
March 30, 2004 at 2:04 pm
First, that's NOT a large database. I've restored a 200+ GB database (yes, that's GIGABYTE).
Next, how did you do the restore? Can you post your script?
It looks like you may...
March 30, 2004 at 1:45 pm
You cannot change the way DATETIME datatype is stored. It's not stored as a date and/or time. It's eight-bytes, with the first four-bytes the number of days after or before...
March 30, 2004 at 1:41 pm
David,
Haven't seen any more from you on this, have you tried this solution as I suggested:
CREATE TABLE #Tbl_PageInfo2 (
Page_ID Int ,
Title VARCHAR(250) ,
Updated_Date SmallDateTime ,
Valid_From SmallDateTime ,
Valid_Till SmallDateTime ,
Position Int)
SET...
March 30, 2004 at 11:05 am
Check out this Microsoft SQL Server webpage:
It's a tool kit that includes:
SQL Scan:
SQL Scan (Sqlscan.exe) scans an individual computer, a Windows domain, or a range of IP addresses for...
March 30, 2004 at 7:37 am
If the .mdf is truly corrupted, I don't know of anything that wil fix/repair it.
Do you have backups?
-SQLBill
March 29, 2004 at 1:03 pm
Viewing 15 posts - 2,146 through 2,160 (of 2,904 total)