RE: Converting DATETIME to NUMERIC
DECLARE @dt DATETIME Set @dt = '1/1/1901 12:01'Select Convert(int,@dt)
2004-06-14
database
RE: Fragmentation 101
I have a server where there is heavy file fragmentation but it is quite busy and cannot be down for long periods of time. Is there any way other than shutting down SQL Server that would allow me to run a defrag on the datafiles while the the database files are in use?
2004-05-11
Where clause based on case
I may need to exclude Fridays, Saturdays, Sundays or any combination of those from a select statement. I have flags set up to tell me which days to exclude. For example, if sun_flag = 'Y' and sat_flag = 'Y', then I want to exclude them from my select statement. How can I do this?I'm getting […]
2004-03-12
2004-02-22
funny results using view to oracle ...
getting unexpected results when using a view with data from a linked oracle DB. Here's the case. I created a view in SQL and joined to the linked oracle db. the view works fine when i select all data from the view, however when i add a where clause such as "select * from my_view […]
2004-02-19
3 reads
RE: Question of the Day for 10 Feb 2004
I cannot find anywhere that the fastest RAID 5, in any configuration, is faster than RAID 1. I am apparently wrong in that assertion. I withdraw my complaint with the original question. I agree…the answer is RAID 1. Who says you can’t teach an old dog a new trick.
2004-02-10
RE: Question of the Day for 29 Jan 2004
I didn't know that you could license SQL Server to a person. I thought there were only two licensing options.CALPer processorIn my case I deal exclusively with systems accessible via the web so only per processor applies to me.Most people don't give a pair of fetid dingos kidneys about licensing until FAST come knocking at […]
2004-01-29
RE: REPLACE function help!
Thanks to all. I will test the CASE option as well as the view. The temp table could be an option later. I created a store proc this morning and will test that one too. Thank you again.
2004-01-28
RE: Version Control
Using Visual SourceSafe to Version control tables and views requires a lot of manual intervention and as such can be very problematic.
2004-01-19
RE: Connecting to SQL Server Using a 'trusted id'
What about creating "staging" tables that you grant Windows groups to and then have jobs run that actually perform the requests.. This way you can manage the security and the job can get done. Also, this would help set you up for the future to switch to sp's because the groups would already be in […]
2004-01-02
1 reads
Blogs
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
EightKB 2024 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2024 Edition has been announced!...
Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory
By Steve Jones
I had a customer that was looking to document a restore that had occurred...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers