Out of curiosity, why are you using dynamic sql, looking at this query, I cannot see the need for it?

😎

tswalton (11/9/2014)

---

Thanks for the reply. I actually found a really quick solution to the problem that I'm not sure is documented anywhere.

I was trying this

select * from tblDomains where (domain...

Quick suggestion, use the charindex or patindex functions

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @URL VARCHAR(150) = 'mywebsite.co.uk/folder/page.html';

DECLARE @tblDomain TABLE

(

Domain_ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED

...

Quick example, more info here sp_executesql (Transact-SQL)

😎

DECLARE @COL_NAME NVARCHAR(128) = N'service_id';

DECLARE @PARAM_STR NVARCHAR(255) = N'@COL_NAME NVARCHAR(128)';

DECLARE @SQL_STR NVARCHAR(MAX) = N'

SELECT

...

Ed Wagner (11/8/2014)

---

Something must have happened with the spam filter. In the Recent Posts...Posts Added Today, there were 3 actual posts across the 4 pages. All other posts...

Quick thought, nothing wrong with the DROP/RENAME approach, just remember to re-create any foreign key constraint etc. if applicable. Another way of doing this is to switch partitions, normally quicker...

imran 60091 (11/7/2014)

---

I have a package that imports and transforms xml files provided by a third party vendor. This process has been failing since the vendor changed attribute names in...

Quick though, since you are already using sp_executesql, you should consider passing the parameter using the parameter string parameter of that procedure.

😎

Quick thought, it might be easier to query the sys.partitions for the row count

😎

;WITH LIST_TABLE AS

(

SELECT

T.object_id

...

Just got an "interesting" email via SSC, Steve are you expanding the "service"?

😎

tim_harkin (10/28/2014)

---

Solved it myself. When I looked at 'C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\SQLServer2014\setup.exe' the file size was 0 KB. I renamed that to setup.exe.old, and re-ran the installer...

Jeff Moden (11/7/2014)

---

qinzhen (11/7/2014)

---

Eirikur Eiriksson (11/6/2014)

---

There are several ways of doing this, somewhat depends on the circumstances which fits best.

Quick questions:

1) Does each file have a single format (number of...

ufrufr (11/7/2014)

---

Eirikur Eiriksson (11/6/2014)

---

Quick thoughts, first is that the non-clustered index is not a covering index and will require an additional key lookup to satisfy the query output. Therefore the...

niladri.primalink (11/6/2014)

---

Hi All,

Hope you are doing great. I want to know one thing. I have idea on SMK, DMK and symmetric and asymmetric keys. I have also idea on TDE....

Quick thoughts, first is that the non-clustered index is not a covering index and will require an additional key lookup to satisfy the query output. Therefore the server simply deems...