steve.clarke-1124563 (6/12/2012)

---

I have a table that contains department and names ;

Department char(20)

Name1 char(20)

Name2 char(20)

Name3 char(20)

Name4 char(20)

Name5 char(20)

Name6 char(20)

I want to be able to read the above table and then insert...

Adam Bean (6/12/2012)

---

Eugene Elutin (6/12/2012)

---

You don't need the cursor! If you have the calendar table, just select records you need filtering by date.

Or you can use some run-time...

AK1516 (6/12/2012)

---

not yet ... after i saw the message above i monitored the replication for 1 hour.. saw no progress in the replication monitor screen....so dropped the article I...

3.I am Clear with the Point that INSERT\DELETE can causes the FRAGMENTATION.

But How Does Update Affects can be cause of Fragmentation..It not even release any Space of Acquire any Space.Please...

I'm pretty sure that both responses are the same for the poll. However, I chose "No." I see no good reason to separate SSIS onto its own instance.

Start the logreader agent?

Here is a quick sample.

CREATE TABLE #testtally (n int)

INSERT INTO #testtally

SELECT 0

UNION ALL

SELECT 1

UNION ALL

SELECT 2

UNION ALL

SELECT 3

DECLARE @startDate datetime

DECLARE @endDate datetime

DECLARE @dateDiff int

SET @startDate = '2012-06-12'

SET @endDate = '2012-06-14'

SET...

Adam Bean (6/12/2012)

---

Thanks, I do have a calendar table; however the problem remains, inserting a new record based on a source data set with every possible date between a specified...

Looks like a permissions issue to me...

Adam Bean (6/12/2012)

---

Hey all,

Trying to figure out the best course of action for taking a given data set that has a start date and inserting a record for all values...

GilaMonster (6/11/2012)

---

Yes, actually it would, but...

Grizzly Bear (6/11/2012)

---

Sorry, I should have been a little bit more explicit in my question

I do not know which query uses which index to run the execution plan.

I know there...

Lynn Pettis (6/11/2012)

---

SQLKnowItAll (6/11/2012)

---

tamil.selvanmca (6/11/2012)

---

CardNo DateTime GateEntry

00000002012012-06-1108:34:23MainGateEntry-Big

00000002012012-06-1108:38:30FF LAB-8...

tamil.selvanmca (6/11/2012)

---

CardNo DateTime GateEntry

00000002012012-06-1108:34:23MainGateEntry-Big

00000002012012-06-1108:38:30FF LAB-8 Entry ...

Grizzly Bear (6/11/2012)

---

I know I can get when an Index was used last from sys.sm_db_index_usage_stats.

But how can I figure out what query used that index , be it...