;With due respect, additional and extra semicolons between statements will not cause any problems and CTE statements will run, without the semicolon it will not.

😎

imrannimran (3/29/2015)

---

Hi everyone;

I am trying to learn building SSAS tabular model. While following a tutorial I need to add a column to an existing table but for some reason the...

SQL_ME_RICH (3/29/2015)

---

Hello -

I am in the midst of testing out a migration for SQL 2012 servers from SP1 to SP2, and am trying to get them to CU5, but...

I know I'm not doing a...

Thanks for the question Steve!

Now I can see yet another discussion on Terminators vs. Beginingnators coming, must say I'm with the latter as my muscle memory punches a semicolon whenever...

Check if UDP port 1434 is open in the firewall.

😎

pallav.sheth (3/27/2015)

---

Hi,

I am trying to install SQL server 2005 Ent edition "en_sql_2005_ent_x64_dvd.iso"(downloaded from MSDN). I am getting and error

"Error 193 Installing .NET Framework 2.0" when installing.

On this machine

1. there...

Check out this excellent article by Koen Verbeeck What’s the deal with Excel & SSIS?[/url]

😎

Quick thought, it may be worth looking into splitting the table in two, one for the "Tasks" and another for the "Process attempts", so instead of updating the column a...

Quick note, you need to post more information, this is not enough!

😎

Have a look at this article: Solving SQL Server Database Physical File Fragmentation[/url]

😎

This...

What the code example demonstrates is that even if the error message is passed up to the application, it wouldn't make much of a difference as the cursor will still...

Quick suggestion, use the MERGE (Transact-SQL) statement

😎

First result I got was A Better sp_who2 using DMVs (sp_who3)

😎

On the tin...