Viewing 15 posts - 19,546 through 19,560 (of 26,484 total)
Only if it is running a virtual machine running a Windows OS. SQL Server can't be installed directly on a non windows OS.
July 24, 2009 at 9:08 am
Gift Peddie (7/24/2009)
No comprehension problem, you are blaming Toshiba for your failure to properly protect your work should you experience a hardware failure.
Do I have it right?
Actually no data backup...
July 24, 2009 at 9:05 am
Actually Jeff, please do post the url when you find it.
July 24, 2009 at 8:51 am
Gift Peddie (7/24/2009)
July 24, 2009 at 8:49 am
Gift Peddie (7/24/2009)
July 24, 2009 at 7:35 am
Could be how the data was moved around in the datapages as it was converted. More pages could have been allocated to store the same amount of data.
July 24, 2009 at 7:29 am
TAman (7/24/2009)
WHERE DATEDIFF(mi,L1.Start_Entry,L2.Start_Entry) < 60 AND Start_Entry BETWEEN '07/01/09' AND '07/23/09'
I get...
July 24, 2009 at 7:27 am
Yes, you also need the cast to varchar(17) for ProjectID in the select statement as well. Good catch, be sure to do it in the third query in...
July 24, 2009 at 7:14 am
Srikanth Anumalasetty (7/24/2009)
Ok, i have another question. Whether a table with ntext column having 1 million records occupy 7GB space?
Consider this, each row of the ntext (or nvarchar(max)) column could...
July 24, 2009 at 7:11 am
saby (7/24/2009)
columns names a ,b c, d
a b c d
1 5 5 =10
2 4 10 = 14
3 8 14 = 22
i want to write a query so...
July 24, 2009 at 12:36 am
manoj2001 (7/23/2009)
But i have change compatibility level from 100 to 90 then took a backup of 2008 database.
logically this should work, if i am not wrong.
please...
July 24, 2009 at 12:30 am
Unless you are having disk space issues on your server, I would not shrink the database.
July 24, 2009 at 12:28 am
I also made a couple of changes to my rewrite. I'd like you to test it out as well when you get a chance.
WITH TRAF (
...
July 24, 2009 at 12:24 am
Hopefully I caught it in all the right places.
SELECT
timesheet.ProjectId as Job_ID_Timesheet,
timesheet.TaskCode as Cost_Code_Timesheet,
timesheet.Name as Cost_Code_Description_Timesheet,
...
July 24, 2009 at 12:19 am
Viewing 15 posts - 19,546 through 19,560 (of 26,484 total)