Viewing 15 posts - 5,851 through 5,865 (of 8,761 total)
Sioban Krzywicki (4/3/2015)
Koen Verbeeck (4/3/2015)
Eirikur Eiriksson (4/3/2015)
Koen Verbeeck (4/3/2015)
It's Friday and I'm grumpy...http://www.sqlservercentral.com/Forums/Topic1674050-3412-1.aspx
Are you grumpy because you are working on the Good Friday or was it the last night "preparation"...
April 3, 2015 at 6:58 am
Depending on the usage, distribution and cardinality, there are few options to speed this up.
😎
One would be adding a calculated column and then index the column, this has little...
April 3, 2015 at 6:53 am
Koen Verbeeck (4/3/2015)
Eirikur Eiriksson (4/3/2015)
Koen Verbeeck (4/3/2015)
It's Friday and I'm grumpy...http://www.sqlservercentral.com/Forums/Topic1674050-3412-1.aspx
Are you grumpy because you are working on the Good Friday or was it the last night "preparation" for it...
April 3, 2015 at 6:47 am
Koen Verbeeck (4/3/2015)
It's Friday and I'm grumpy...http://www.sqlservercentral.com/Forums/Topic1674050-3412-1.aspx
Are you grumpy because you are working on the Good Friday or was it the last night "preparation" for it that make you grumpy?...
April 3, 2015 at 6:39 am
sqlmaverick (4/2/2015)
I have to eliminate comma in last field of a file in flat file connection manager. when I check the source file I didn't see any commas but...
April 3, 2015 at 6:37 am
jasona.work (4/3/2015)
That one actually seems to be missing from the most recent SQL STIG guide I grabbed.
I use this Microsoft SQL Server 2012 Database Security Technical Implementation Guide[/url]
😎
Apart from the...
April 3, 2015 at 6:31 am
jasona.work (4/3/2015)
April 3, 2015 at 6:06 am
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
Viewing 15 posts - 5,851 through 5,865 (of 8,761 total)