sgmunson

Forum Replies Created

Viewing 15 posts - 1,906 through 1,920 (of 4,820 total)

RE: Implications of slower writes with 64K pages using SSDs vs SAN

NJ-DBA - Monday, November 13, 2017 9:27 AM
As part of our migration to SQL Server 2017, we are considering a move to...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

November 14, 2017 at 7:37 am

#1967960
RE: Shared stored procedure with very complicated input

patrickmcginnis59 10839 - Thursday, November 9, 2017 3:43 PM
As to your "Why cursors? Well why not." comment, there's a really simple...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

November 14, 2017 at 7:06 am

#1967954
RE: Modifying my parameterized query to select * an entire column

leavesandmusic - Friday, November 10, 2017 11:51 AM
Thank you, so I assume the code would look like this?
Sub ClickButton()
Dim SQL As ADODB.Command
Set...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

November 14, 2017 at 6:50 am

#1967949
RE: Doing multiple updates with an ADODB Connection

leavesandmusic - Sunday, November 12, 2017 3:13 PM
Thank you for your help Eirikur. Any idea why your suggestion does not work for...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

November 14, 2017 at 6:41 am

#1967946
RE: Doing multiple updates with an ADODB Connection

leavesandmusic - Friday, November 10, 2017 9:14 AM
Thank you for your suggestion, but I cannot use a stored procedure in this instance. ...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

November 10, 2017 at 12:55 pm

#1967584
RE: load data into 3 separate tables using tsql .

vsamantha35 - Wednesday, November 8, 2017 2:32 PM
Always the first row will be a bunch of characters indicating a header and date...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

November 10, 2017 at 12:45 pm

#1967576
RE: Does Anyone know how you can copy values from a previous row into a null column in SSIS

Jeff Moden - Wednesday, November 8, 2017 12:34 PM
sgmunson - Wednesday, November 8, 2017 6:43 AM
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

November 9, 2017 at 1:22 pm

#1967454
RE: Shared stored procedure with very complicated input

mcraig 42832 - Wednesday, October 18, 2017 6:22 AM
Jeff Moden - Tuesday, October 17, 2017 8:12 PM
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

November 9, 2017 at 1:18 pm

#1967453
RE: standalone instances - 300 DBs 2 TB worth - how to sync

sqlguy80 - Thursday, November 9, 2017 8:55 AM
thanks. The changes are not that much ... `5-10 GB that's it per day on...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

November 9, 2017 at 9:05 am

#1967411
RE: Sizing CPU for consolidating Servers

alex.palmer - Thursday, November 9, 2017 8:50 AM
I completely agree but I'm not in control of the purse strings! If the price...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

November 9, 2017 at 8:56 am

#1967408
RE: standalone instances - 300 DBs 2 TB worth - how to sync

sqlguy80 - Tuesday, November 7, 2017 6:26 PM
Hi DBA Gurus,
I've been assigned a task first to propose a plan including scripts and...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

November 9, 2017 at 8:47 am

#1967402
RE: Sizing CPU for consolidating Servers

I'd be a lot more interested in knowing what kind of CPU usage you are already experiencing, and Perf Mon stats would certainly be useful in that regard. If you...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

November 9, 2017 at 8:37 am

#1967399
RE: Replication

I don't suppose that processing the response message requires Kerberos authentication because of the remote server? This is a total stab in the dark..
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

November 8, 2017 at 6:59 am

#1967150
RE: Where are the "official" SQL 2017 logo's?

Found the image here: https://www.google.com/search?q=SQL+2017+logos&tbm=isch&source=iu&pf=m&ictx=1&fir=C6GgD7yLUKZGgM%253A%252CNU6YaCfj1CNf5M%252C_&usg=__NziTTt4T8PxoyKUslO7qa-aYZ0U%3D&sa=X&ved=0ahUKEwicqOS-j6_XAhUisVQKHdXbDnoQ9QEINDAA#imgrc=C6GgD7yLUKZGgM:
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

November 8, 2017 at 6:54 am

#1967149
RE: Does Anyone know how you can copy values from a previous row into a null column in SSIS

aaron.reese - Wednesday, November 8, 2017 4:09 AM
I would still prefer to connect to the source database and run the select statement...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

November 8, 2017 at 6:43 am

#1967147

Viewing 15 posts - 1,906 through 1,920 (of 4,820 total)