Viewing 15 posts - 46 through 60 (of 629 total)
The first question would be how are you creating the file?
August 3, 2011 at 2:47 pm
Nevyn (8/3/2011)
cengland0 (8/3/2011)
GSquared (8/3/2011)
August 3, 2011 at 2:18 pm
what is the purpose of doing a convert to varchar?
I would suggest that the problem is that you ae not finding any results as none exist.
Is the time always 00:00:00.0000...
August 3, 2011 at 12:33 pm
Freddie-304292 (8/3/2011)
cengland0 (8/3/2011)
GSquared (8/3/2011)
August 3, 2011 at 10:40 am
GSquared (8/3/2011)
Dan.Humphries (8/3/2011)
I love that people are actually claiming that we need to look to...
August 3, 2011 at 9:10 am
So I have been reading through these posts and I can not stop laughing.
I love that people are actually claiming that we need to look to the government...
August 3, 2011 at 8:54 am
Are you asking about the service account use by SQL server or are you talking about creating an Application role inside of SQL?
June 30, 2011 at 1:51 pm
Personally I would try to do this using a join rather than a subquery but you also need to break it down to a one to one relationship. What...
June 28, 2011 at 8:14 am
I am not sure what you are trying to do with this line but this would be where the problem is.
you do not get it when you test with a...
June 28, 2011 at 7:57 am
Select
datediff(d,Start_Date,End_Date) - (select count(*))
from table_b
where table_b.datecol >= table_a.StartDate
and table_b.datecol <= table_a.EndDate) As TotalDays
from Table_A
I am not sure I understand what you are trying to acomplish with this...
June 27, 2011 at 2:00 pm
that is a rather braod request. do you have a specific question?
June 21, 2011 at 2:01 pm
I woul dbe curious why you could not add a primary key. Assuming these are used for an app you could safely add a PK with out affecting the...
June 21, 2011 at 1:59 pm
You know I don't know that I really gave it much thought. My mind just said that made sense and I went with it. But now that I...
June 17, 2011 at 12:16 pm
The Full DB Backup runs about an hour when it is at a TB but less then 10 minutes when it is reduced to the 100GB size.
June 16, 2011 at 2:33 pm
Not to beat the proverbial dead horse here but I thought I would point out one such situation where we do a regular shrink of database files. I am...
June 16, 2011 at 2:07 pm
Viewing 15 posts - 46 through 60 (of 629 total)