Forum Replies Created

Viewing 15 posts - 1,411 through 1,425 (of 13,460 total)

  • RE: Disabling Index operations for certain tables in SQL Server 2008 R2 other than DDL trigger

    DDL triggers are great for tracking whodunnit info, but rolling back operations can have a performance impact, as you identified.

    I think using a DDL trigger to prevent index operations is...

    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!

    October 29, 2015 at 5:54 am

    #1836317

  • RE: Refreshing a table using CREATE TABLE, DROP and Rename

    i do something very similar, but i rename the original table just in case, along with any indexes/constraints/defaults/foreign keys.

    then rename the temp table, and it's indexes/constraints/defaults/foreign keys to match 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!

    October 28, 2015 at 1:30 pm

    #1836197

  • RE: Sending out emails.

    SQLPain (10/28/2015)

    yeah that's true, currently I have more than 50 jobs set up on reporting server, all with funky name, don't know how to figure out which one is associated...

    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!

    October 28, 2015 at 12:58 pm

    #1836189

  • RE: Trigger and email notification

    Sergiy (10/27/2015)

    I would strongly recommend not to run sending emails or any other kind of external operations from a trigger.

    And glitch in the functionality beyond SQL Server control may cause...

    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!

    October 28, 2015 at 6:13 am

    #1835999

  • RE: Need a Query to Capture all the information In SQL

    New persopn (10/27/2015)

    Thanks for your information.

    Is there any query to capture the information like Type of Backup, Mode of Backup information in SQL server

    Backups occur on a per database level,...

    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!

    October 27, 2015 at 1:15 pm

    #1835886

  • RE: Need a Query to Capture all the information In SQL

    New persopn (10/27/2015)

    Hi All,

    We are in the process of creating inventory, for that I need a query to capture the below information

    HostName

    InstanceName

    Version

    Edition

    SQL Service Account

    Region

    Zone

    Server Managed By

    Storage Managed By

    Backup Managed By

    Type...

    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!

    October 27, 2015 at 12:31 pm

    #1835875

  • RE: Select part of a text string...

    here's one way to do it:

    since i want to find the second slash, i know i can use charindex to start at char 4 in your path.

    /*

    X:\folder\anotherfolder\X:\folderX:\folder\yet another folder\X:\folderX:\foldername\another folder\X:\foldernameX:\foldername\yet...

    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!

    October 26, 2015 at 11:35 am

    #1835573

  • RE: How do you setup a listener within SQL2008?

    in that case, the assumptions really incorrect.

    an entire SQL Service listens to a specific port; on a default instance, the default port is 1433, but, yes, it can be...

    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!

    October 26, 2015 at 11:04 am

    #1835568

  • RE: Restoration without sysadmin pemission

    a person with db_owner on the database has the ability to backup / restore or drop the database they own.

    if they drop it, they most likely would not have 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!

    October 26, 2015 at 6:00 am

    #1835485

  • RE: Sql objects - TFS

    if you have visual Studio 2012 , if you install the SSDT package from microsoft, you can create a new database project.

    that has a wizard to point to a database,w...

    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!

    October 23, 2015 at 6:12 am

    #1835137

  • RE: dm_os_sys_memory and dm_os_sys_info

    i think you have to switch to dynamic sql for an all in one script right?

    something like this?

    Declare @serverID int,

    @Memory int,

    @Edition varchar (200),

    @Version varchar (200),

    @CoreCount int

    select @serverID = server_id from...

    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!

    October 22, 2015 at 1:09 pm

    #1835009

  • RE: Group by doesnt work

    DDL, sample data and expected results then?

    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!

    October 22, 2015 at 12:57 pm

    #1835007

  • RE: How do we find columns that have default constraints

    based on some of your other posts, it looks like you are trying to script out a table definition.

    take a look at my procedure i wrote in this article and...

    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!

    October 22, 2015 at 12:51 pm

    #1835005

  • RE: Group by doesnt work

    since there's more than one row, and you only want to group on one column, you need an aggregate function;

    any of these would be my first examples to see what...

    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!

    October 22, 2015 at 12:44 pm

    #1835001

  • RE: Get DDL for any SQL 2005 table

    interesting;and i think i see the issue...my script might not be case sensitive.

    is this database case sensitive?

    can you run this command?

    SELECT

    DATABASEPROPERTYEX(db_name(),'Collation') ...

    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!

    October 22, 2015 at 11:24 am

    #1834984

Viewing 15 posts - 1,411 through 1,425 (of 13,460 total)