Matt Miller (#4) (9/15/2014)

---

Grant Fritchey (9/15/2014)

---

Eirikur Eiriksson (9/15/2014)

---

Grant Fritchey (9/15/2014)

---

I'd think the easiest way to do this would be to cheat. Rename it. Then name it back.

But, that could cause...

Quick thought, use the CONCAT function, no need to worry about overlapping operators

😎

DECLARE @INT INT = 10000;

DECLARE...

ScottPletcher (9/15/2014)

---

All of those seem far too disruptive to me.

Two quick possibilities:

1) Add an optional parameter to the proc which requires a certain value or the proc just exits (or...

Grant Fritchey (9/15/2014)

---

I'd think the easiest way to do this would be to cheat. Rename it. Then name it back.

But, that could cause errors in the code if it tries...

Quick thought, don't ever use geometry for geographical data, use geometry with the appropriate SRID, normally 4326.

mickyT's solution is straight forward, just make certain that the direction is correct...

f.welten (9/11/2014)

---

I'm facing the same problem, which Isolation levels did you try? I have two options: ReadCommited and Snapshot. Currently it is on ReadCommited, before I'm changing it to Snapshot,...

BWFC (9/15/2014)

---

Eirikur Eiriksson (9/15/2014)

---

Quick solution, allows for variable length input

😎

;WITH SAMPLE_DATA(MOBILE) AS

(SELECT * FROM

(VALUES

('9334457582')

...

Quick solution, allows for variable length input

😎

;WITH SAMPLE_DATA(MOBILE) AS

(SELECT * FROM

(VALUES

('9334457582')

...

Here is my suggestion

Leave the identity to the destination table, don't use the identity_insert. Consider dropping the non clustered indexes and recreate them after the load. In addition, an SSIS...

Either re-run the command or check for SQLDUMPnnnn.txt file in the SQL Server Log directory.

One error is...

Another option if the sa login is not available is to run SSMS as Administrator and make the necessary changes.

😎

WhiteLotus (9/15/2014)

---

Eirikur Eiriksson (9/15/2014)

---

Quick question, by disabling it do you mean make it do nothing, make it disappear from the...

Quick question, by disabling it do you mean make it do nothing, make it disappear from the user's view or...

Quick questions:

1. Is...

nam.lenhat (9/14/2014)

---

Hello everyone,

I am using SQL 2014, but having problem :

When I use query in a table (having big data ..over one hundred million rows). I just query about...