Viewing 15 posts - 5,851 through 5,865 (of 8,754 total)
For starters can you post the DDL (create table) for the tables and some consumable sample data in the form of an insert statement? This will increase your chances of...
April 3, 2015 at 6:00 am
Looks like the only thing missing is actually to execute the dynamic sql
😎
EXEC (@sql);
April 3, 2015 at 5:20 am
Quick solution
😎
USE tempdb;
GO
SET NOCOUNT ON;
GO
DECLARE @strname varchar(50) = '3 April 15 abcd Oh rrrrrrrAAAAdd HJHJG';
DECLARE @SAMPLE_DATA TABLE
(
SD_ID INT NOT NULL
,SD_TEXT...
April 3, 2015 at 5:01 am
Ravid_ds (4/3/2015)
Hi Experts,Can you please share your experiences on what basis should we decide to go with Page or ROW Compression?
Quick answer, it depends.
😎
Start by reading through these articles
...
April 3, 2015 at 3:20 am
Quick point, the temporary table resides in the tempdb, change the db part of the object_id function's parameter to point to it.
😎
/* Any User Database */
USE Test;
GO
/* The temporary table...
April 3, 2015 at 1:27 am
Quick thought, use READPAST rather than dirty read
😎
April 2, 2015 at 3:38 pm
whereisSQL? (4/2/2015)
Eirikur Eiriksson (4/2/2015)
Revenant (4/2/2015)
Ed Wagner (4/2/2015)
djj (4/2/2015)
whereisSQL? (4/2/2015)
SQLRNNR (4/2/2015)
BWFC (4/2/2015)
ExhibitionExhibitionist
Voyuer
Voyager
Space
Balls
shooting
stars
voyage
April 2, 2015 at 3:33 pm
Revenant (4/2/2015)
Ed Wagner (4/2/2015)
djj (4/2/2015)
whereisSQL? (4/2/2015)
SQLRNNR (4/2/2015)
BWFC (4/2/2015)
ExhibitionExhibitionist
Voyuer
Voyager
Space
Balls
shooting
April 2, 2015 at 2:29 pm
djj (4/2/2015)
Ed Wagner (4/2/2015)
Eirikur Eiriksson (4/2/2015)
Revenant (4/2/2015)
BWFC (4/2/2015)
ExhibitionArt
Conceptual
Abstract
Impressionism
Footprint
April 2, 2015 at 8:56 am
Revenant (4/2/2015)
BWFC (4/2/2015)
ExhibitionArt
Conceptual
April 2, 2015 at 7:54 am
Quick advice, use the DelimitedSplit8K [/url]function if you are on SQL Server 2008 or dbo_DelimitedSplit8K_LEAD[/url] if you are on 2012 and later
😎
April 2, 2015 at 7:27 am
djj (4/2/2015)
crookj (4/2/2015)
Ed Wagner (4/2/2015)
Eirikur Eiriksson (4/2/2015)
BWFC (4/2/2015)
djj (4/2/2015)
Eirikur Eiriksson (4/2/2015)
djj (4/1/2015)
Eirikur Eiriksson (4/1/2015)
Ed Wagner (4/1/2015)
SQLRNNR (4/1/2015)
cunningGuile
Salesman
Used Car
Bargain
Basement
Cellar
Wine
Italy
Colosseum
Death
Tourist
April 2, 2015 at 7:20 am
BWFC (4/2/2015)
djj (4/2/2015)
Eirikur Eiriksson (4/2/2015)
djj (4/1/2015)
Eirikur Eiriksson (4/1/2015)
Ed Wagner (4/1/2015)
SQLRNNR (4/1/2015)
cunningGuile
Salesman
Used Car
Bargain
Basement
Cellar
Wine
April 2, 2015 at 6:05 am
MVIT (4/2/2015)
April 2, 2015 at 3:49 am
djj (4/1/2015)
Eirikur Eiriksson (4/1/2015)
Ed Wagner (4/1/2015)
SQLRNNR (4/1/2015)
cunningGuile
Salesman
Used Car
Bargain
April 2, 2015 at 2:02 am
Viewing 15 posts - 5,851 through 5,865 (of 8,754 total)