Viewing 15 posts - 3,091 through 3,105 (of 7,429 total)
I have played with and tested many things with SQL and they seem to have optimized the engine when using SQL92 Syntax of INNER/LEFT/RIGHT/OUTER as opposed to , seperated and...
April 25, 2003 at 9:08 am
Unfortunately, Yes. If you want the old data to match then all data will need to be UTC. But the code I posted will handle that conversion from Eastern to...
April 25, 2003 at 9:03 am
I too agree you should store as UTC, if you need to have the data show as Local Time I have SQL code that can do this. But you can...
April 25, 2003 at 6:40 am
I could not duplicate the issue. Where are you running this from?
April 25, 2003 at 6:28 am
Sorry, I didn't understand. I generally don't deal with other groups with that specific type of need. I am an island to myself altough I do import and export data...
April 25, 2003 at 6:21 am
That was what I was affraid of. However weekends can be handled with the following.
SELECT
T1.[DATE],
T1.TABLENAME,
T1.NOOFRECORDS,
(T1.NOOFRECORDS - ISNULL(T2.NOOFRECORDS,T1.NOOFRECORDS)) AS DIFF
FROM
ABC T1
LEFT JOIN
ABC T2
ON
T1.TABLENAME =...
April 25, 2003 at 5:01 am
Can moderator lock this thread. Please post/see comments in thread http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=11654&FORUM_ID=24&CAT_ID=1&Topic_Title=Backup+Tips&Forum_Title=Backups
April 25, 2003 at 4:48 am
Another way that seems a bit cleaner since CONVERT actually performs a read of the syslanguages table. Would be to do like so.
DATEADD(d,DATEDIFF(d,0,GETDATE()),0)
April 25, 2003 at 4:42 am
Nevermind it hit me just now, so here is an example that cross breeds int with varchar to handle bitmask via substring position to mark it.
SET...
April 25, 2003 at 4:36 am
The biggest bitwise mask you could create with numbers is 127 possible values using decimal/numeric type with precision of 38 and scale of 0. Here is code to generate those...
April 25, 2003 at 4:23 am
You might try schduling as a Job that runs continuously.
Create basic Job by scheduling the package in EM. Open Agent and go into the Job. In the jobs Steps open...
April 25, 2003 at 4:07 am
You should use CAST instead of CONVERT this is where MS is going with things.
CAST((sum(d.length)/1000) AS decimal(10,2))
April 25, 2003 at 4:00 am
Since you state is recorded on a daily basis then you should not have gaps in data. If that is the case this may run better with the same results.
...
April 25, 2003 at 3:55 am
Another thing you need to keep in mind is referential integrity. I usually put static items in on FileGroup and for performance reasons may seperate large tables that a related...
April 25, 2003 at 3:44 am
Just an added note after I had a chance to really look over the index hint. Compared to an ORDER BY clause it does not neccessarily match if the values...
April 25, 2003 at 3:31 am
Viewing 15 posts - 3,091 through 3,105 (of 7,429 total)