Viewing 15 posts - 6,301 through 6,315 (of 9,715 total)
y.koteswarrao-652921 (3/4/2008)
HiIn a transaction log file , how a checkpoint works, and it's process,plz clarify.
Once you've read the suggested material, if you still have questions, post the part of the...
March 16, 2011 at 11:31 am
I believe SQL uses the same logic as it uses for Excel worksheets. It checks the first 10 rows of data and assigns nullability (as well as data type) based...
March 16, 2011 at 11:30 am
I would go with John's suggestion with one suggestion. If you are using a third party backup & restore tool, like Litespeed, you can do object restores. Which means you...
March 16, 2011 at 11:04 am
Can you add another file to your transaction log on a different drive and make it the Primary? Given enough space, trying to shrink your database or your data file...
March 16, 2011 at 11:01 am
EDIT: Erasing what I just said because it's not related to the question. DOH.
If your growth occurs at a certain point in the day, can't you use profiler to identify...
March 16, 2011 at 10:55 am
Craig Farrell (3/15/2011)
March 16, 2011 at 4:39 am
Also glad you got it working and thanks for posting the solution. That will help others with the same problems.
March 15, 2011 at 7:31 am
GSquared (3/15/2011)
Brandie Tarvin (3/11/2011)
But Parsename() only works because it's treating the IPAddress as a Server.Database.Schema.Object item (because of the...
March 15, 2011 at 7:30 am
Wow. Just finished beta-reading for Craig.
Wow.
Aren't you guys sad you can't see that article yet and jealous that I got to read it before you did! @=)
March 15, 2011 at 7:29 am
Craig Farrell (3/13/2011)
March 14, 2011 at 7:06 am
Here's a unique way of doing the special / invisible character search. Your mileage may vary:
DECLARE @y xml;
SET @y=(SELECT MyID, MyColumn
from MyTable where MyColumn=''
FOR XML RAW, ELEMENTS XSINIL);
SELECT convert(varchar(5000),@y);
EDIT: You'll...
March 14, 2011 at 6:02 am
Now that's an interesting solution I never would have thought of.
But Parsename() only works because it's treating the IPAddress as a Server.Database.Schema.Object item (because of the periods). It wouldn't...
March 11, 2011 at 12:01 pm
Ah. Stefan found the Substring version I was trying to do. I forgot about starting location in CharIndex(). No wonder I couldn't get it to work.
You're welcome, Roy. Glad we...
March 11, 2011 at 11:27 am
Viewing 15 posts - 6,301 through 6,315 (of 9,715 total)