Viewing 15 posts - 571 through 585 (of 921 total)
Cross-posted (and answered) in the Administration forum.
--Jonathan
--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...
--Jonathan
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...
--Jonathan
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...
--Jonathan
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...
--Jonathan
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,...
--Jonathan
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...
--Jonathan
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...
--Jonathan
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...
--Jonathan
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.
--Jonathan
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
--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,...
--Jonathan
October 29, 2003 at 2:27 pm
quote:
Is it possible to alter an existing FK constraint to allow cascades on update or delete?
--Jonathan
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...
--Jonathan
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...
--Jonathan
October 29, 2003 at 9:09 am
Viewing 15 posts - 571 through 585 (of 921 total)