Viewing 15 posts - 46 through 60 (of 628 total)
The first question would be how are you creating the file?
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
August 3, 2011 at 2:47 pm
Nevyn (8/3/2011)
cengland0 (8/3/2011)
GSquared (8/3/2011)
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
August 3, 2011 at 12:33 pm
Freddie-304292 (8/3/2011)
cengland0 (8/3/2011)
GSquared (8/3/2011)
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
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?
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
June 27, 2011 at 2:00 pm
that is a rather braod request. do you have a specific question?
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
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.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
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...
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
June 16, 2011 at 2:07 pm
Viewing 15 posts - 46 through 60 (of 628 total)