JayK (4/2/2013)

---

ALTER DATABASE [master] MODIFY FILE ( NAME = master , FILENAME = 'J:\Log\SystemLog\mastlog.ldf' );

ALTER DATABASE model MODIFY FILE ( NAME = modeldev , FILENAME = 'J:\Log\SystemLog\modellog.ldf' );

i.e. I renamed...

Sean Lange (4/2/2013)

---

If you are going to go...

Getting the current record HAS to be a performance hit. What you're talking about is a logging table. I use them all the time and I prefer them...

Sounds like a poor man's version of Service Broker. Not a bad idea, considering the steep slope of knowledge needed to get Broker up and running properly.

sqldba_newbie (3/22/2013)

---

yup, if i multiple number of executions with actual number of rows...

Jeff Moden (3/21/2013)

---

You're joining to an indeterminent value and at execution plan time, it can't determine what to join on and so it ignores the predicate. Look at the...

EDIT: Please ignore this entire post. One dog, wrong tree, right forest.

I am well aware of the bad contractors out there... I'm a contractor myself. I've actually called back to the home company and told them to pull bad contractors...

Biank (3/21/2013)

---

I'm trying to create indexes on a table that will hold all of data changes in any columns of any tables so the number of rows will be pretty...

itlk (3/21/2013)

---

A/ Why the join yields different results for CTE and for the real table?

B/ If I replace the join in the query No 1 with RIGHT OUTER JOIN, the...

In SSRS, go to the display box for...

Need to see the sqlplan. Offhand I'd guess there's a spool with multiple executions.

dhananjay.nagarkar (3/21/2013)

---

Hi Craig,

since I do not want to lose the date in the Report hence seems the best suggestion is in DB to do this change instead of DATE TIME...

A) What is the base datatype for the field? I hope DATETIME.

B) Why? The front end/reporting server can do this so much easier, and end users shouldn't be...

I'm agree with Sean here. Dynamic SQL has it's place as an optimization tool, particularly when dealing with parameterization and sniffing.

Doing dynamic SQL against a dynamic SCHEMA screams so...