Forum Replies Created

Viewing 15 posts - 2,926 through 2,940 (of 13,460 total)

  • RE: Last one hour database status

    like SQLSACT said, you need something in place already to get "by hour" counts.

    for example, this query gets the # of rows in each table. if you saved the results...

    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!

    November 19, 2013 at 7:02 am

    #1667385

  • RE: Using SSMS 2008 with SQL 2012

    late response, but here's my advice: switch to using the 2012 SSMS immediately.

    the differences are minor, but they are there, and there's no valid reason to be afraid of 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!

    November 19, 2013 at 6:16 am

    #1667367

  • RE: Server side trace question

    Perry Whittle (11/19/2013)

    sunny.tjk (11/18/2013)

    The steps of the job are

    (1)start trace

    (2)run the trace for 2 mins

    (3)stop trace

    ??

    Like Perry, I'm not sure where the question is, but i'll throw out 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!

    November 19, 2013 at 6:09 am

    #1667366

  • RE: Problem with my procedure

    my first guess is that you ar emissing a GO statement;

    you've got the CREATE / ALTER, and then a call of the same proc on the last line...so it calls...

    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!

    November 18, 2013 at 2:49 pm

    #1667248

  • RE: Mass Delete Just Hangs

    raysteve43 (11/18/2013)

    I am trying to upgrade to SQL 2012 from SQL 2005. I have a job that deletes expired records from a single table one a month....

    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!

    November 18, 2013 at 2:45 pm

    #1667246

  • RE: Distributed Transaction Coordinator behavior?

    answering my own question:

    found a post that referenced "linked server" along with the error;

    it pointed out that toggling this option on the linked server from true to false resolved 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!

    November 18, 2013 at 12:40 pm

    #1667221

  • RE: Breaking 3NF to save a join - should I do it?

    assuming you would join Source_X_Entity to the other two tables ,

    i would think that if you create a non clustered index on Entity(NaturalKey), or maybe a non cluster on(Entity(EntityID)...

    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!

    November 18, 2013 at 9:14 am

    #1667178

  • RE: Auditing Database usage

    benjamin.reyes (11/18/2013)

    Sounds like a good use case for a logon trigger.

    http://technet.microsoft.com/en-us/library/bb326598.aspx

    but a logon trigger would not tell what or when a database was accessed; it only fires at login, 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!

    November 18, 2013 at 9:03 am

    #1667175

  • RE: Performance problem with Views defined against Linked Server data sources

    yeah that's one of the problems with a linked server; data gets copied over to tempdb, and then joined to your data locally, so you could see a million+ row...

    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!

    November 18, 2013 at 8:59 am

    #1667173

  • RE: (RVO) script runs 5 sec with hard-coded value - 45 sec using parameter!

    ahperez (11/18/2013)

    Well, since this is a third-party app this might not be a practical option. Auto update stats is a database level command, impacting the whole db. Below is 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!

    November 18, 2013 at 7:56 am

    #1667141

  • RE: Strange SQL Results. Example Included.

    temp_int_field DOES NOT EXIST in #sub_table, it's a column in #temp.

    because you are not aliasing your columns, it isn't obvious that that is the issue at first glance.

    --this works, becuase...

    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!

    November 18, 2013 at 7:46 am

    #1667136

  • RE: redgate SQL search

    George i have the Redgate SQL Search plugin added, and it searches meta data only: object names from sys.objects, and definition text from sql_modules.

    Sean Lange And I have a couple...

    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!

    November 18, 2013 at 7:16 am

    #1667129

  • RE: Auditing Database usage

    winston, i think one of the built in extended events session templates, along with where you would add a filter on database Id, is probably what i'd look at first.

    In...

    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!

    November 18, 2013 at 6:29 am

    #1667118

  • RE: using Mid(User!UserID,10) as a default in a parameter ?

    i think there is a built in function for that, [&UserID], right?

    Getting Windows USERID in SSRS report

    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!

    November 15, 2013 at 2:01 pm

    #1666833

  • RE: Function to list passenger names?

    dba schema, or was that a misspelled dbo?

    here's my code modified to use your table...if you spelled your tables and columns right, i think this will work as advertised, assuming...

    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!

    November 15, 2013 at 1:07 pm

    #1666827

Viewing 15 posts - 2,926 through 2,940 (of 13,460 total)