Viewing 15 posts - 5,011 through 5,025 (of 6,679 total)
verbalh (6/17/2009)
June 17, 2009 at 10:37 am
Florian Reischl (6/17/2009)
Using an indexed view is a solution I really had to see. Let me justify with the...
June 17, 2009 at 10:17 am
only4mithunc (6/17/2009)
but the solution is like keeping unique value in the column and allowing more than one NULL value....
but my...
June 17, 2009 at 10:07 am
only4mithunc (6/17/2009)
since by default the unique identifire is non-clustured , the records should be in the same order I have inserted na..?
By definition, a table has no order. The...
June 17, 2009 at 9:41 am
Flo, if you are trying to allow more than a single null, but everything else is unique there are two methods that I would recommend:
1) Use a nullbuster column (coined...
June 17, 2009 at 9:40 am
GilaMonster (6/17/2009)
Yeah, I figured it out a while back. I still consider it broken.
Of course 😀
June 17, 2009 at 9:04 am
GilaMonster (6/13/2009)
And the quote button from time to time.
Interesting you say that cause I have seen it a couple of times now. I think I have it figured out.
If...
June 16, 2009 at 5:18 pm
Glad you got it to work - just had to do that myself today. Installed the latest version to restore a backup on a new server. One of...
June 16, 2009 at 5:07 pm
Also, since you are on 2005 you should change the page verification to CHECKSUM (once you have this issue resolved).
June 16, 2009 at 12:45 pm
Is the drive a dedicated drive for tempdb? If it is, then you really just need to identify why tempdb grew to that size and monitor for additional growth.
If...
June 16, 2009 at 12:14 pm
Where are you clicking on modify? Are you trying to modify the SQL Server Agent job, or the Maintenance Plan?
For SSMS Maintenance Plans, you should not modify the agent...
June 16, 2009 at 11:47 am
iqtedar (6/15/2009)
i did try that with extractor...it works..but for some reasons it is splitting the litespeed backup into 14 different sql native client backups..thanks everyone
You are getting 14 files because...
June 15, 2009 at 5:40 pm
Lynn Pettis (6/15/2009)
June 15, 2009 at 12:40 pm
drodriguez (6/15/2009)
I'll stick with converting it to a varchar first then a date field.Thank for your guys help.
Dave
Yeah, that is probably going to be the best option. If...
June 15, 2009 at 12:25 pm
drodriguez (6/15/2009)
Yes, that worked and is slightly better. But is there anyway to convert from int to datetime?Thanks,
Dave:-)
Yes, you can convert directly from INTEGER to DATETIME. However, you cannot...
June 15, 2009 at 12:16 pm
Viewing 15 posts - 5,011 through 5,025 (of 6,679 total)