Quick question, why not use sys.sp_updatestats?

😎

super48 (4/18/2015)

---

hi

I have 2 packages in my project. I am using 2008 r2

I have made changes to one I dont want to deploy both .I want only one packaged...

Jason-299789 (4/17/2015)

---

Hi

We have Virtual SharePoint DB server with 16GB ram, 1 socket 4 virtual CPU's running at 2ghz.

Yesterday around 6:30am the CPU on this box started going haywire (90%),...

keshab.basnet (4/18/2015)

---

1. my Production log file is 59 GB. and My data file is 44 GB. It seems Log file is larger than Data file. I do regularly Full database...

hurricaneDBA (4/18/2015)

---

Just to clear the water

I am not referencing 2 sessions, i run a script daily and create/drop a local temporary table daily hence my original question was concerning...

Quick solution which uses dbo.DelimitedSplit8K[/url]

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE @SAMPLE_STR VARCHAR(500) = 'adventure,devotion,for children,happiness,imagination,love,world,lovely,confusion,introspection,on work and working,on writing and words,';

DECLARE @SEARCH_WORD ...

nicklarge1973 (4/17/2015)

---

Hi. A multi data transfer without ETL transforms, just a 1-1 column transfer finishes 940 tables within a 1 hour 30 minute window. The amount of data transferred is...

Quick solution, similar to the one Ozzmodiar posted, with an additional POC index which eliminates any sorting operations in the execution plan.

😎

USE tempdb;

GO

SET NOCOUNT ON;

IF OBJECT_ID(N'dbo.testTable') IS NOT NULL DROP...

Mark Cowne (4/17/2015)

---

Try this

WITH CTE AS (

SELECT cust_Id,sDate,budget,

ROW_NUMBER() OVER(PARTITION BY cust_id ORDER BY sDate) -

ROW_NUMBER()...

Further on Alan's reply, this is an incomplete query, first guess would be that it's from a BMC Dashboard, try to capture the whole query.

😎

Yes it is, I would ask...

Quick and somewhat naïve ( compared to Dwain's ) solution

😎

Note: added 'a'-->'@' for demonstration purposes 😉

USE tempdb;

GO

SET NOCOUNT ON;

/* sample data */

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

CREATE TABLE...

Passed

Conflict

Build