Archive for

Incorrect syntax near “GO”

SQL Error (102): Incorrect syntax near “GO”   DON’T USE NVARCHAR FOR SQL VARIABLES HOLDING BATCHED SQL STATEMENTS WITH IMBEDDED “GO” STATEMENTS…   I recently wrote some code to generate CRUD procedures for a Data Warehouse project and I was receiving an error message on the batch T-SQL “GO” statement when executing the sql code … Continue reading

Set it or Select it?

I get asked this question quite frequently regarding which to use in a T-SQL statement, SET or SELECT. I personally use SET 90% of the time, if for not other reason then my development background(readability). Here’s what I know about the differences between SET  & SELECT: SET is the ANSI standard for assigning values to … Continue reading

SSAS Full Cube Processing Logon failure: unknown user name or bad password.

I recently received the error “Logon failure: unknown user name or bad password “ when performing a database Process Full on a tabular model. What made this particularly strange is that I know I was able to perform a Process Full in the past few days and  could currently perform a Process Default on the … Continue reading

SQL Server Version List

Quick summary: Version RTM (Gold, no SP) SP1 SP2 SP3 SP4 SQL Server 2014 12.00.2000.8         SQL Server 2012 11.00.2100.60 11.00.3000.0 11.00.5058.0     SQL Server 2008 R2   10.50.1600.1 10.50.2500.0 or 10.51.2500.0 10.50.4000.0 or 10.52.4000.0     SQL Server 2008 10.00.1600.22 10.00.2531.0 10.00.4000.0 10.00.5500.0   SQL Server 2005 9.00.1399.06 9.00.2047 9.00.3042 … Continue reading