sgmunson

Forum Replies Created

Viewing 15 posts - 946 through 960 (of 4,820 total)

RE: Insert-Update Concurrency Simulator

GonnaCatchIT - Wednesday, July 11, 2018 12:02 AM
Dear All,
I have a application with SQL Server 2008 r2 DB which creates some Ticket...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

July 11, 2018 at 11:11 am

#1997165
RE: Efficient way to load data in a table

I'd be curious to see if each of the 10 separate years of data could be constructed as inserts in SQL tasks inside a Data Flow within SSIS, and to...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

July 11, 2018 at 10:59 am

#1997163
RE: Pivoting a 2 columns table to a 6 columns table with 1/3 the rows

Given that the source data contains an ordering mechanism, using ROW_NUMBER() isn't actually needed here:
Declare @xImage AS TABLE (
rowNumber int,
xImage char(10),
...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

July 11, 2018 at 9:45 am

#1997150
RE: SSRS Fixed Position Rectangles

jim.powers - Wednesday, July 11, 2018 7:47 AM
Thank you for trying! It's good in the designer but when I deploy to the...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

July 11, 2018 at 8:20 am

#1997131
RE: Calculate timespan between datetime field in multiple records

fnillerfnaller - Tuesday, July 10, 2018 1:01 PM
sgmunson - Tuesday, July 10, 2018 10:08 AM
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

July 11, 2018 at 6:49 am

#1997114
RE: Why would changing the compatibility mode affect parallelism in a query?

Sue_H - Tuesday, July 10, 2018 10:48 AM
In addition to updating the stats, I would check the cost threshold for parallelism....
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

July 11, 2018 at 6:33 am

#1997113
RE: Changing network packet size

alex.palmer - Friday, June 29, 2018 10:44 AM
Hi
our network has an MTU of 1500 so I've changed the network packet size to...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

July 10, 2018 at 10:40 am

#1997023
RE: SQL Over network slow

Sue_H - Tuesday, June 26, 2018 1:43 PM
Jackie Lowery - Monday, June 25, 2018 6:54 PM
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

July 10, 2018 at 10:37 am

#1997022
RE: Why would changing the compatibility mode affect parallelism in a query?

lindsayscott23 - Monday, June 25, 2018 6:33 AM
Hi,
We changed the compatibility mode from 100 (2008) to 110 (2012) on a 2012 Enterprise...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

July 10, 2018 at 10:30 am

#1997021
RE: I need to extract the 5 char length substring between dashes

jeffshelix - Tuesday, July 10, 2018 10:15 AM
example
asdfasf-ABCDE-asdfasdfsfasf
ss-TREWQ-asdfasfsf
(the column is CI_NUM where that value lives)
i need the 5 characters between the dashes
help,...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

July 10, 2018 at 10:20 am

#1997017
RE: Calculate timespan between datetime field in multiple records

fnillerfnaller - Tuesday, July 10, 2018 9:05 AM
sgmunson - Tuesday, July 10, 2018 6:45 AM
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

July 10, 2018 at 10:08 am

#1997016
RE: SSRS Fixed Position Rectangles

jim.powers - Tuesday, July 10, 2018 8:58 AM
Hmmm, good thought! The floorplan image has a size of 17.3in x 9.1in so I...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

July 10, 2018 at 9:31 am

#1997005
RE: Dynamic SQL using sp_executesql with DbName parameter

Budd - Tuesday, July 10, 2018 8:14 AM
What am I doing wrong in this statement or one like it?
DECLARE @SQLString nvarchar(500); ...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

July 10, 2018 at 8:41 am

#1996978
RE: SSRS Fixed Position Rectangles

jim.powers - Tuesday, July 10, 2018 7:45 AM
I haven't tried to print it. The image of the floorplan is too large for...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

July 10, 2018 at 8:34 am

#1996975
RE: Query Return No Meta Data When Values are Null

Your query doesn't have any inherently dynamic columns in it, so I have to GUESS that you are using a presentation or reporting tool that does some kind of pivot...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

July 10, 2018 at 8:29 am

#1996972

Viewing 15 posts - 946 through 960 (of 4,820 total)