wendy elizabeth (10/7/2016)

---

In a t-sql 2012 listed below, I want the lockids to be set individually from 117173 to 117678. The problem with the sql listed below is all the...

For completeness, 5 different versions which all produce the same execution plan although performance may vary depending on the XML structure.

😎

----------------------------------------------------------------------------

-- #1 Full traverse to the end node

----------------------------------------------------------------------------

SELECT Id...

You are very welcome.

😎

The value of the sys.dm_exec_sessions.host_process_id is defined...

Quick thought, no need to use the traversing operator "//" in the nodes path statement, it can be costly if the XML is complex.

😎

Non traversing examples

SELECT Id ,

...

joshua 15769 (10/7/2016)

---

So what I did is, save the username in the database through stored procedure. The stored procedure is called in the program prior to update. but sadly, I...

matt.warren 33350 (10/7/2016)

---

Hello,

I have a table called "Tables" which stores a list of tables by id, name, etc.

I also have a table called "Columns" which stores a list of columns...

itmasterw 60042 (10/7/2016)

---

Hi,

I have a package that is using a Foreach File Enumerator loop to go through a folder and pull in the data from a 3 Excel files; insert...

Grant Fritchey (10/7/2016)

---

Brandie Tarvin (10/7/2016)

---

Stuart Davies (10/7/2016)

---

I don't post here often, but love the community...

Quick suggestion

😎

USE TEEST;

GO

IF OBJECT_ID(N'dbo.temp') IS NOT NULL DROP TABLE dbo.temp;

create table dbo.temp(Companyid varchar(10) not null,companyname varchar(100) not null,DateFrom datetime not null, DateTo datetime null);

INSERT INTO temp values('A1','A Company','2000-04-11',null);

INSERT INTO...

You can retrieve the file growth events from the default trace[/url]

😎

marc.corbeel (10/6/2016)

---

I have this problem I cannot solve. In a stored procedure I need to make a select query. A parameter passed to the SP tells to select only the...

Nice write-up Drew, well done!

😎

One thing I missed seeing in the article was the mentioning of a POC index which is absolutely essential when working with the window functions, especially...

george sibbald (10/5/2016)

---

Lynn Pettis (10/5/2016)

---

george sibbald (10/5/2016)

---

well that's me done. I retire today so this will be my last post.

I made it into the top 30 posters at one point...

This one is purely for entertainment, it's not very efficient with 4 table scans and an expensive sort in the execution plan. It does on the other hand demonstrate some...