Viewing 15 posts - 14,236 through 14,250 (of 26,486 total)
Export to a tab delimited file and import that to Excel.
October 17, 2011 at 4:09 pm
Don't know off the top of my head how to check this, but a swag would be CHECKPOINT. I could be wrong.
October 17, 2011 at 4:03 pm
Sean Lange (10/17/2011)
Interesting exercise. What is the reasoning? Just for fun/learning? SARGability? If so, the ones Lynn posted look good for 2 and 3 but 1 still has a convert.
Look...
October 17, 2011 at 3:36 pm
I guess this goes back to the original question, is it a true null value or a string saying 'null'.
October 17, 2011 at 2:29 pm
Check out PragmaticWorks, http://pragmaticworks.com/Products/Business-Intelligence/TaskFactory/Features.aspx
October 17, 2011 at 2:25 pm
1) isnull(t1.col1, convert(datetime, @var1)) <= convert(datetime, @var1)
-> t1.col1 <= convert(datetime, @var1) or t1.col1 is null
2) isnull(t1.col2, '0') = '1'
-> t1.col2 = '1'
3)...
October 17, 2011 at 2:22 pm
Okay, I'm sure we could come up with seberal versions of the data sorted by shift. It eould help if you showed us what you rxpect based on the...
October 17, 2011 at 1:10 pm
cdelgross (10/17/2011)
October 17, 2011 at 11:58 am
I will answer your last question. After deleting the data from the table, SQL Server also needs to update any non-clustered indexes that reference the data deleted.
October 17, 2011 at 11:46 am
Depends on what edition of SQL Server 2008 you are running.
If native compression is available, use it. If not, you may want to look at a third party backup...
October 17, 2011 at 10:52 am
sqlfriends (10/17/2011)
I think it is created a new file each time it run, because I see timestamp on...
October 17, 2011 at 10:40 am
jared-709193 (10/17/2011)
Lynn Pettis (10/17/2011)
Select COUNT(SerialNumber),
CASE WHEN DATEPART(hour,(DateTested)) between 7 AND 16 THEN '1st SHIFT'
WHEN DATEPART(hour,(DateTested)) between 16 AND 1 THEN '2nd SHIFT'
WHEN DATEPART(hour,(DateTested)) between 1 AND 7 THEN '3rd...
October 17, 2011 at 10:37 am
Please remember that each differential backup backs up all changes since the last full backup.
If you are truncating all the tables and reloading each night it makes since that over...
October 17, 2011 at 10:33 am
Did you check the SQL Serror log as well? There may be more information in other logs that would help identify the problem.
October 17, 2011 at 10:23 am
Viewing 15 posts - 14,236 through 14,250 (of 26,486 total)