Days

Koen Verbeeck (8/5/2015)

---

I have been nominated again for Author of the Year at MSSQLTips.com. For some reason they already started the voting process, which runs until the end of the...

sumit4bansal (8/5/2015)

---

I have a table with 8 columns, I need to update data in multiple columns on this table, this table contains 1 million records, having single update was taking...

Corn

haichells (8/4/2015)

---

Hello everyone,

I am trying to run a query from a Linked server "ABCD"

Set @SQLCMD = 'Select * from TableName"

Insert into @TempTableName

Execute (@SQLCMD) AT ABCD

I am getting below error while...

chandrika5 (8/4/2015)

---

This is SQLSERVER 2008 with the management studio. I have a simple table with 250 rows. This table is updated via a web app.

On SQL SERVER management studio:

1.simple query...

Act

sgmunson (8/4/2015)

---

Eirikur Eiriksson (8/4/2015)

---

sgmunson (8/4/2015)

---

According to MS doc, that applies only...

yb751 (8/4/2015)

---

Raise your hands if you like Entity Framework...then I'll know who to shoot!

Sorry just needed two seconds to vent. :crazy:

I'm sure like anything else it can be fine when...

sgmunson (8/4/2015)

---

According to MS doc, that applies only to SQL 2014...

Tail

Quick suggestion, use sys.dm_exec_describe_first_result_set or sys.dm_exec_describe_first_result_set_for_object, to get the structure of the output of the stored procedure.

😎

Did you just discover a modern dr. jekyll and mr. hyde?

😎

Alvin Ramard (8/3/2015)

---

SQLRNNR (8/3/2015)

---

Lynn Pettis (8/3/2015)

---

Read the following comment made today by Silver Spoon on a 4 year old thread:

ok, thank you very much.

I inherited these databases so I'm very...

Next question, how many rows in a normal batch?

😎