sharonsql2013 (4/30/2015)

---

Does datediff hinders performance in queries.

I am trying to access the records and it takes almost 40 seconds to filter out of 180000 rows. Which is not much of...

Simple solution using the DelimitedSplit8K [/url]function

😎

USE tempdb;

GO

SET NOCOUNT ON;

declare @Address table(Id int primary key identity(1,1),Address varchar(100),city varchar(20),State varchar(20))

insert into @Address

select '123 sheril street, Newyork,NY','Newyork','NY' union all

select '333 bamboo street, Manhattan,NY',...

Quick thought, safe your self from any future grieve and wipe it! In other words, do a fresh install of the OS and the SQL Server.

😎

Mark Cowne (4/22/2015)

---

Assuming weeknumber is contiguous you can do this

SELECT a.WeekNr,a.Data

FROM mytable a

WHERE EXISTS(SELECT * FROM mytable b

...

latingntlman (4/29/2015)

---

Hello, the subject pretty much says it all. I have the following result set but I want to stack or transpose the 3 fields into a single column. I...

WilliamPhill (4/29/2015)

---

I have a PC that had sql 2005 running on it that has died. The OS is corrupt and wont boot / repair at all.

I have managed to get...

Distance

Hubble

ramana3327 (4/29/2015)

---

Hi,

How can we monitor the all tables in all databases and send notifications to the team.

Is there a way to check to find the no of rows and size...

This is what I use, SFTP Task for SSIS

😎

Mirrors

Gun

There are few ways of doing this, which is best depends on the usage. This sample makes the assumption that the table is only queried for a specific insert date...

Quick question, what are the memory configurations for the SQL Server service (min/max memory)?

😎

Quick thought, the order of the columns is irrelevant and cannot be set, neither by a create nor alter statement. The ordinal position is the representation and has nothing to...