Brandie Tarvin (3/22/2011)

---

You are misreading that entry. It says it truncates, not shrinks. Truncate allows SQL to reuse the portion of the log that was just freed. It's like eating...

If you don't understand this, just ask.

declare @date1 datetime,

@date2 datetime;

set @date1 = GetDate();

set @date2 = '20110511 08:00:00'; -- start date of sql...

Lynn Pettis (3/26/2011)

---

Okay, poll time. How many of you are getting tired of Celko and his high horse?

I may be wrong, but I think I could count on one...

You'll want to query the system views directly:

select * from sys.key_constraints

select * from sys.default_constraints

select * from sys.foreign_keys

select * from sys.check_constraints

select * from sys.indexes

It should be pretty obvious what each is...

Search this site for detecting gaps and islands - you're going to be interested in the islands.

(Posting tip: when posting dates, include a "SET DATEFORMAT DMY" so that people in...

David Krauus (3/25/2011)

---

Thank you. this does work, but on a table with 14K rows (and growing) it's too slow for our needs (about 6 seconds). This needs to be...

Please check out the two articles in my signature: CrossTabs and Pivot Tables, Parts 1 and 2. This should give you all the information you need for how to do...

Use the DelimitedSplit8K function. Here is the latest version of the Delimited Split Function.

And you would use it like this:

-- make and populate a table to hold the test data

DECLARE...

Would this suffice?

execute sp_msforeachtable 'sp_helpindex ''?''';

You can use "select * into table from OpenRowset / OpenQuery (executing your stored procedure)".

You need to use the delimited split function: Here is the latest version of the Delimited Split Function.

Then, use this code:

-- make and populate a table to hold the test...

1. Is the end result the output from the select, or do you need those two columns updated in the table?

2. Are the DayID_in values always going to be consecutive...

You know, the people that help out here are all un-paid volunteers, so please HELP US HELP YOU. Providing the DDL scripts (CREATE TABLE, CREATE INDEX, etc.) for the tables...

No need to repost here, now that we know it's 2008 in the other thread.

Please post responses here.

Just to verify - you're using sql 2008? I ask because you posted in the sql 7/2000 forum, but your code has sql2008 syntax in the declare statement.