Forum Replies Created

Viewing 15 posts - 1,096 through 1,110 (of 13,460 total)

  • RE: Upgrade SQL Express to Enterprise

    there's no upgrade path for Express to non express versions; instead you need to backup all the databases, script out your logins, as well as anything server related...certificates, linked servers,...

    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!

    April 27, 2016 at 5:30 pm

    #1875121

  • RE: Trigger - Display Updated Fileds

    a trigger has a COLUMNS_UPDATED integer value which represents a bitmask for the columns that were mentioned in the update, but it does not tell you if the value changed...

    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!

    April 27, 2016 at 9:45 am

    #1874988

  • RE: Results of sys.dm_exec_procedure_stats are disordered

    is this on a cluster, where it might be failing over or toggling to the other node?

    is it possible someone is downing the server for maintenance?

    did you check the...

    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!

    April 27, 2016 at 6:17 am

    #1874902

  • RE: AVG Function not working as expected.

    i think it's integer division. SQL maintains the datatype, and the avg is truncated to a integer.

    change the datatype of the column from int to decimal(19,4) and you get 2.5

    Declare...

    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!

    April 26, 2016 at 3:27 pm

    #1874807

  • RE: Does T-SQL have a means of iterating over the columns of a table?

    if the table has an implicit or explicit ordering, like an identity() column, or a CREATEDDATE datetime column, you can compare old to new in a set based operation, by...

    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!

    April 26, 2016 at 3:02 pm

    #1874802

  • RE: Audit information in to table

    SQL Server Import and Export Wizard

    https://msdn.microsoft.com/en-us/library/ms141209.aspx

    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!

    April 26, 2016 at 12:58 pm

    #1874773

  • RE: Pulling all object name alone form various Queries

    well i dug a little deeper in my old parser utility.

    i expected the tables to be identified as TOKEN_TABLE, but they end up being TOKEN_ID instead; i guess with a...

    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!

    April 26, 2016 at 12:29 pm

    #1874753

  • RE: Just fetches one record in 10 lakhs

    INNER JOIN (

    SELECT Top 1

    that will return one , single row, not one row per policy number, right?

    so the other table is limited to match one row as...

    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!

    April 26, 2016 at 9:29 am

    #1874674

  • RE: Pulling all object name alone form various Queries

    from a string representing a query, it's difficult, just as Grant said; you have to tokenize it in a SQL parser. It's quite a bit of work, i did it...

    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!

    April 26, 2016 at 7:19 am

    #1874591

  • RE: Automate data script generation.

    It's really, really easy to script out a backup and restore,and with just a bit of tweaking and testing, make it fully automated.

    For example, I have a job that restores...

    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!

    April 26, 2016 at 7:10 am

    #1874581

  • RE: How to dynamically determine how many columns and their names that are in a work table

    i use something like this to generate models of both an insert and an update statement, assuming a staging table of the same name;

    does this get you started?

    you would...

    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!

    April 25, 2016 at 1:48 pm

    #1874368

  • RE: how do i capture the result set from a query into a variable @SQLstr so I can exec(@SQLstr)

    duplicate post.

    original discussion is here, lets keep it all together to prevent fragmentation of replies:

    http://www.sqlservercentral.com/Forums/Topic1779526-338-1.aspx

    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!

    April 25, 2016 at 1:45 pm

    #1874367

  • RE: SQL Server monitoring tools

    the real question is what is your budget;

    the top tools cost money, typically ~1000 per server, with discounts against more and more servers.

    is your job going to shell out 100K...

    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!

    April 25, 2016 at 1:38 pm

    #1874365

  • RE: Automate data script generation.

    backup and restore would be my first choice too, unless you can come up with a decent reason to avoid it.

    if you are really going to script it out,

    there's...

    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!

    April 25, 2016 at 1:16 pm

    #1874357

  • RE: Need t-sql to list all enabled and scheduled SSRS jobs

    something like this should get you started;

    select

    e.name

    ...

    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!

    April 25, 2016 at 7:43 am

    #1874232

Viewing 15 posts - 1,096 through 1,110 (of 13,460 total)