Look up DATEADD in Books Online. You can also CONVERT the date to a string and concatenate a string representation of the time and then CAST all that back...

Best of luck in your endeavor.

madhu-686862 (10/8/2013)

---

I'm planning to set up AlwaysOn Availability Groups.

Questions:

1. Can one cluster node should be enoguh to configure AlwaysOn Availability Groups?

2. The node hosting the secondary replica, must be part...

I hadn't heard that reverse engineering sql objects was deprecated in Visio 2013!! That kinda sucks for a lot of people I think.

Anyway, I HIGHLY recommend Embarcadero's ERStudio product. ...

You either shrink or you export all data, build a new database, and import all data.

I am afraid that getting deeper into why you cannot shrink the database file (it...

It could well be the tlog that is taking up all the space you see in that particular output. try dbcc sqlperf(logspace) and see if you have a huge...

Glad you got it fixed! Well, glad MICROSOFT fixed it!! 🙂

I am coming across...

Thomas Mucha (9/26/2013)

---

I am looking into AlwaysOn Availabilty Groups as both an HA and load spreading solution. But there is something I would like to clarify before I present to...

GilaMonster (9/26/2013)

---

Temp tables are logged. There are NO unlogged operations in SQL other than inserts into the...

Knut Boehnert (9/25/2013)

---

It depends.

If the structure is stable and the same at every import I prefer to use a permanent temp table. That is define the permanent table with a...

1) sp_whoisactive (sqlblog.com I think version 11.11 is latest)

2) track_waitstats_2005 (found in the sql server 2005 waits and queues white paper IIRC) to do a wait stats analysis

3) run a...

DDL triggers. However, these can be disabled by users with sufficient permissions so they are not fool-proof.

I always default...

We need to see the query plan to help.

But you might try inserting the SELECT stuff you need for the update into a temp table (NOT table variable) and running...

A text editor is the minimum you need to create a new schema (CREATE TABLE abc ...). 🙂

SSMS has a totally crappy ability to do this graphically (see the Database...