Nonsense. The only reason you ever need to ban SELECT * from...

PHYData DBA (1/26/2015)

---

mike.gallamore (1/26/2015)

---

Or applications that sit on top of someone else's database: say health care systems, CRM etc. Often it becomes the job of the front end guys to...

John Mitchell-245523 (3/27/2015)

---

Yes, expand the files manually if you can, at a time of low activity. I would recommend that you leave auto-grow enabled, in case of any unexpected...

So far as SQL Server database work is concerned, I'm strictly an SSMS man. Used to use Query Analyser and Enterprise manager. I've never touched SSDT. This...

trboyden (3/27/2015)

---

Pretty much live in SSMS and code T-SQL in my sleep. However if writing a .NET app, I'd be curious why the discussion is SSDT versus using the Entity...

Brandie Tarvin (3/27/2015)

---

ChrisM@Work (3/27/2015)

---

TomThomson (3/27/2015)

---

dwain.c (3/26/2015)

---

...

Edit: This query shows the same thing:

IF EXISTS (SELECT 1 FROM (VALUES(CAST(1 AS BIT))) d (n))

SELECT * FROM sys.all_columns;

Which means that it has something...

RFI

Good question.

In both versions I've had (2.0,4.0) the returns from (Get-Host).Version, $psversiontable.PSVersion, and $Host.Version have been identical - so perhaps from version 2.0 onwards the powershell version and the ConsoleHost...

sestell1 (3/26/2015)

---

I think whether the file gets created depends on if the syntax error causes the package to fail validation or not. I think the second question also depends...

Stewart "Arturius" Campbell (3/26/2015)

---

If there is a Syntax error in the script to create a job, the job will not be created.

however, if the syntax error is in the command...

dwain.c (3/26/2015)

---

...

Edit: This query shows the same thing:

IF EXISTS (SELECT 1 FROM (VALUES(CAST(1 AS BIT))) d (n))

SELECT * FROM sys.all_columns;

Which means that it has something to do with the...

Jeff Moden (3/26/2015)

---

I believe that the reasons for that are many...

1. It's a scalar UDF.

2. It does calculations instead of using constants.

3. It doesn't take advantage of...

Jeff Moden (3/26/2015)

---

My recommendation would be to do those kinds of checks externally rather than adding them to the function. Changes for convenience will slow things down when it's...

I...

Solomon Rutzky (3/26/2015)

---

peter-757102 (3/26/2015)

---

Gary Harding (3/26/2015)

---

Solomon Rutzky (9/4/2014)

---

Jeff Moden (9/3/2014)

---

I guess I'd have to disagree. Nulls mean "Unknown" and it is definitely known that there are no values on...