Viewing 15 posts - 571 through 585 (of 921 total)
Cross-posted (and answered) in the Administration forum.
--Jonathan
October 30, 2003 at 6:18 am
quote:
Specially this onehttp://www.mvps.org/vbnet/index.html?code/locale/gettimezonebias.htm
I'm not going to spend any more time on this, but you'd...
October 30, 2003 at 6:09 am
quote:
Although I use these methods myself, I support Jonathan in that you *should* consider doing this not on the server, but within...
October 30, 2003 at 5:57 am
20 CALs in SQL 7 meant that you could choose either "per seat" or "per server" licensing model. With one server, the obvious choice was "per server", as that...
October 30, 2003 at 5:43 am
Perform a transaction log backup and then shrink the file. In BOL, see BACKUP LOG and DBCC SHRINKFILE. Scheduled tran log backups should keep the size under control...
October 30, 2003 at 5:17 am
No, date formats (and the issue is usually with dmy vs. mdy) are determined by the default language, which is for the instance, not database. You can, of course,...
October 30, 2003 at 5:11 am
quote:
Interesting scenario.What if the producer of the data is located in New York, the SQL Server in London and Consumer / Report...
October 29, 2003 at 6:23 pm
quote:
JohnathanThanks for the reply but I have already ruled that solution out as the date may be from a period when the...
October 29, 2003 at 4:46 pm
If you're testing this in Query Analyzer (QA), check the setting in Tools|Options|Connection Properties. The default is for that setting to be checked (true) and will override the server...
October 29, 2003 at 4:28 pm
quote:
awesome article. Thanks!Chris
edit: Of course now... how can I go thru and quickly rename 450+ procs 🙁
Learning is painful.
October 29, 2003 at 4:11 pm
In SQL Server 2000, this will get you the offset from UTC for the server:
DATEDIFF(hh,GETUTCDATE(),GETDATE())
You can then convert back and forth using this offset with DATEADD.
--Jonathan
October 29, 2003 at 4:05 pm
quote:
Currently, if I only care about the date, I can not store only the date. DATETIME will add a default time. So,...
October 29, 2003 at 2:27 pm
quote:
Is it possible to alter an existing FK constraint to allow cascades on update or delete?
October 29, 2003 at 1:24 pm
"go" is a batch directive and is not used within stored procedures. It creates a new batch, which means your local parameters are out of scope because everything following...
October 29, 2003 at 9:58 am
quote:
- Ok, let it be so, but is there a way to keep procedure cache size fixed, to prevent it from being...
October 29, 2003 at 9:09 am
Viewing 15 posts - 571 through 585 (of 921 total)