Forum Replies Created

Viewing 15 posts - 871 through 885 (of 13,460 total)

  • RE: Linked Server Update "Hung"

    homebrew01 (7/29/2016)

    I am doing a pretty simple update of Table_A, based on a join to Table_B

    The query runs on Server_A, via Linked Server to Server_B, where both tables reside.

    If I...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 29, 2016 at 12:49 pm

    #1892709

  • RE: Update all fields in a record except incoming NULL values?

    probably with a CASE statement;

    something like this in your proc(assuming parameters are available for all four fields you mentione:

    update Table1

    SET Field1 = CASE WHEN @Field1 IS NULL THEN Field1...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 29, 2016 at 12:39 pm

    #1892707

  • RE: Migration to Azure - FillFactor needs to be removed on 200+ indexes

    i use this to script out indexes,

    I just tested it an Azure, no problems, of course.

    i've excluded fillfactor in it, you could tweak the statement generation to whatever you...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 29, 2016 at 10:43 am

    #1892696

  • RE: Get DDL for any SQL 2005 table

    thanks for the code review,m.martinelli! you've pointed out items taht made some vast improvements!

    i incorporated all your ideas, but in my own coding style;

    i had not tested against the newer...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 29, 2016 at 8:35 am

    #1892652

  • RE: Get DDL for any SQL 2005 table

    Alan.B (7/28/2016)

    I just ran across this Lowell, it was exactly what I was looking for and has saved me a lot of time (it's 8:50PM in Chicago and I'm still...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 28, 2016 at 8:16 pm

    #1892566

  • RE: Can we log all database user (session) specific data into table?

    i use a variant of this to find procedures that take longer than 15 seconds, tune them one by one, and then lower my threshold until it's a diminishing return...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 27, 2016 at 9:59 am

    #1892334

  • RE: Just a query tool

    Linqpad[/url] is a good alternative; it supports a object explorer type of panel, and multiple tabs with syntax highlighting like SSMS does.

    it's also "portable", meaning you don't have to...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 25, 2016 at 12:46 pm

    #1891880

  • RE: dynamically build an extractor for extended events xml

    thanks for the info guys, i'm diging through the details now.

    I've got a solid handle on what i was after now, a fresh set of eyes got me started.

    I'll post...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 25, 2016 at 9:30 am

    #1891842

  • RE: How to imbed an image into an email sent by dbmail

    a feature of almost all email programs is to not show images without extra user interaction, or not show from untrusted sources. check your application, and see if you can...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 25, 2016 at 4:52 am

    #1891791

  • RE: Trigger to send email on insert

    Will Stillwell (7/22/2016)

    ...the email body doesn't get populated AT ALL....

    I'm betting you are not handling nulls correctly; you have to isnull every column as you build the string, so that...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 22, 2016 at 1:04 pm

    #1891662

  • RE: Get DDL for any SQL 2005 table

    ahh, so you are using some custom data types you've created, right?

    i had assumed the longest string datatype was "uniqueidentifier", and that's where the 16 came from.

    good catch, i'll wiggle...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 20, 2016 at 9:38 am

    #1891100

  • RE: xp_cmdshell throws Access is Denied error

    only a domain account can access server shares, so you'll need to change the service account that SQL is currently running under. NT Service\MSSQLSERVER is not a domain account, so...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 16, 2016 at 1:28 pm

    #1890468

  • RE: Microsoft SQL Developer Certification For beginers

    there's a nice confidence builder to get started:it's testing for basic proficiency with SQL Server.

    MTA 98-364 Database Fundamentals is $115, and there is a track on Virtual Academy for...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 13, 2016 at 10:27 am

    #1889915

  • RE: Column delimiter not found in ssis package

    I've seen upgraded packages change the delimiter to "_0x0044" or something like that, instead of leaving the original comma;

    open the package, and review what the delimiter is in the package...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 8, 2016 at 12:12 pm

    #1889242

  • RE: Cluster is showing the Same drive a few times with "VerificationDisk010" appended to it.

    some more information, i see in the system event view errors referring to mount points being invalid: the network admin is not aware of any mount points being used, if...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 6, 2016 at 6:49 am

    #1888665

Viewing 15 posts - 871 through 885 (of 13,460 total)