chandrika5 (8/7/2015)

---

Just replicated it!.

I am using SQLSERVER Management Studio for both the queries.

1. select * from dbo.mytable

VS

Expand the Instance --> Databases --> tables --> Right click the table and select...

Edit: removed post.

🙂 Smiley

StillaLearner (8/8/2015)

---

Hi - I'm looking for a quick script that someone has already written to update statistics (not to rebuild or re-organise) on specific indices in specific databases - I...

As Jason said, 11.2.xxx is a typo.

😎

BTW, you should be running 11.00.5623, kb 3072100, Cumulative update package 7 (CU7) for SQL Server 2012 Service Pack 2.

Quick question, could there be more than one row returned? You can check this by filtering the set by the given parameters/predicates.

😎

Further, can you post the actual code you are...

studySQL (8/7/2015)

---

I have a data flow that brings the data from flat file (.txt) to a table but after processing few rows, it fails with this error.

Violation of PRIMARY...

Add an identity column, and as it looks the table is a heap so use the opportunity and make it clustered.

Good stuff and you are very welcome

😎

sp_who2

sealed

Jeff Moden (8/6/2015)

---

stevenb 14609 (8/6/2015)

---

I use xp_CmdShell for 2 different things.

One is to export csv reports for end users.

The other one is to export and then FTP files...

Tac11 (8/6/2015)

---

When I run below query I get 3 columns, but when I try to add table name

ind.object_name (object_id) it's giving me an error "Ambiguous column name 'object_id"

How do...

Yogeshwar Phull (8/6/2015)

---

Thanks for the replies.

Well, I am trying to fix something that was already in place for sometime and I have no clue on how the front end works....

I agree with Jeff on this one, nothing is going to be faster than bcp, are all lines in the incoming file the same format/layout?

😎

Now just for fun, here is...