Viewing 15 posts - 14,341 through 14,355 (of 19,564 total)
Lynn Pettis (4/30/2010)
Steve Jones - Editor (4/30/2010)
I think it was OK. From a technical standpoint, it makes sense. The issue seems that some people don't understand log chaining, so things...
April 30, 2010 at 3:23 pm
Steven James Gray (4/30/2010)
April 30, 2010 at 3:21 pm
Here is a useful article on several different methods to calculate the median.
http://www.simple-talk.com/sql/t-sql-programming/median-workbench/
April 30, 2010 at 3:19 pm
MANU-J. (4/30/2010)
whereas sp_spaceused returns index_size of [49928...
April 30, 2010 at 3:12 pm
Steve Jones - Editor (4/30/2010)
CirquedeSQLeil (4/30/2010)
Steve,What is this new content of plagiarism? Where can it be found?
??
In reference to your blog. I was curious to find more info...
April 30, 2010 at 3:09 pm
Lynn Pettis (4/30/2010)
April 30, 2010 at 2:59 pm
jcrawf02 (4/30/2010)
Very nice. Must be like voodoo, I feel ill and alien already.
I was hoping to come up with a squeamish color, but this was the closest match I could...
April 30, 2010 at 2:51 pm
Good to hear.
It seems appropriate to me (your method for changing the connection).
April 30, 2010 at 2:43 pm
jcrawf02 (4/30/2010)
CirquedeSQLeil (4/30/2010)
jcrawf02 (4/30/2010)
:sick::blush::sick::blush::sick::blush::sick::blush::sick::blush::sick:15,000
:alien::rolleyes::alien::rolleyes::alien::rolleyes::alien::rolleyes::alien::rolleyes::alien:
And I was so tempted to do that myself.
I knew you were, but you were being so conscientious about just posting real Threadliness, so figured I'd take...
April 30, 2010 at 2:40 pm
To follow up what Grant said, do you have a way you can limit the results to be deleted? Add a range to the query or something that can...
April 30, 2010 at 2:14 pm
Try this article.
Look at the tail log section.
April 30, 2010 at 2:11 pm
Kenneth Langner Jr. (4/30/2010)
-- Create the temp table for further querying
CREATE TABLE #temp(
rec_idint IDENTITY (1, 1),
table_namevarchar(128),
nbr_of_rowsint,
data_spacedecimal(15,2),
index_spacedecimal(15,2),
total_sizedecimal(15,2),
percent_of_dbdecimal(15,12),
db_sizedecimal(15,2))
-- Get all tables, names,...
April 30, 2010 at 2:09 pm
jcrawf02 (4/30/2010)
:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D15,000
:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D
And I was so tempted to do that myself.
April 30, 2010 at 2:08 pm
I suggest to find what is causing it to be that big. Gianluca proposed a solution. I'll propose another option - read this article[/url] and try it's suggestions
April 30, 2010 at 2:07 pm
What is the status of the database?
In Recovery, Offline, Online?
April 30, 2010 at 2:03 pm
Viewing 15 posts - 14,341 through 14,355 (of 19,564 total)