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...

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...

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...

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...

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. ...

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...

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

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

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...

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...

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...

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...

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..

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:

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...

November 8, 2017 at 6:43 am

#1967147

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