Forum Replies Created

Viewing 15 posts - 2,716 through 2,730 (of 13,460 total)

  • RE: SQL 2008 R2 and custom application built with C# very slow query times causing errors and timeouts

    Banks1850 (12/27/2013)

    statistics are updated daily and automatically for all tables right after the index maintenance is performed.

    and there are none that are listed as out of date when I check.

    I'm...

    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!

    December 27, 2013 at 8:01 am

    #1676086

  • RE: SQL 2008 R2 and custom application built with C# very slow query times causing errors and timeouts

    if it works quickly for a while, and then becomes slow, it sounds like out of date statistics might be the first thing to look at.

    stale statistics can easily slow...

    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!

    December 27, 2013 at 7:45 am

    #1676083

  • RE: how to calculate no.of .months billed customer

    I've got teh same answer ad Ed Wagner does, i just processed your post through a macro so i had some consumable data.

    if you want solid help like that int...

    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!

    December 27, 2013 at 6:57 am

    #1676067

  • RE: Finding Dependencies of Objects

    procs and views referencing your tables are only part of the puzzle;

    applications can have dependencies on those tables, and applications can reference tables that are never used.

    there's a handy chartabout...

    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!

    December 27, 2013 at 5:46 am

    #1676056

  • RE: Update Temp table where the column names are unknown

    info-531323 (12/26/2013)

    In a stored procedure I dynamically create a temp table by selecting the name of Applications from a regular table. Then I add a date column and add 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!

    December 26, 2013 at 1:02 pm

    #1675996

  • RE: merge multiple table coloum data in new table

    INSERT INTO NewTable(name,mobile)

    SELECT name,mobile from a UNION ALL

    SELECT name,mobile from b UNION ALL

    SELECT name,mobile from c UNION ALL

    SELECT name,mobile from d

    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!

    December 26, 2013 at 9:28 am

    #1675966

  • RE: Complex Query

    here's the data you posted, but cleaned up and in a ready to use format:

    the column names in your query did not match the data, and there was no easy...

    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!

    December 26, 2013 at 9:20 am

    #1675965

  • RE: I can't attach my database to SQL Server 2008 Instance

    MohamedDBA (12/25/2013)

    But the compatibility level of the database is - SQL Server 2008 (100) , and this database was created on SQL Server 2008 before I attach It to SQL...

    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!

    December 26, 2013 at 5:53 am

    #1675935

  • RE: Remote Server Tables

    the more updated views under the sys schema, instead of the old dbo.sys* views are recommended instead.

    the view below has both a create_date and modify_date that can help in your...

    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!

    December 26, 2013 at 5:46 am

    #1675931

  • RE: Xmas Transitivity Puzzle

    does joining the table against it self help you visualize the issue?

    this lets us see how some of the items are related to each other:

    --join the table against itself looking...

    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!

    December 24, 2013 at 6:03 am

    #1675762

  • RE: Installing a clustered SQL 2012 instance is extremely slow

    you have to update statistics on all tables with full scan after a version upgrade, or restore of a database from a lower version to a higher;

    the statistics are treated...

    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!

    December 24, 2013 at 5:20 am

    #1675754

  • RE: Split a variable length string without using a WHILE loop

    whoops after reading your post AFTER i posted, i see you really want to chop up the string based on a fixed length(ie 4 chars)

    well, i know an example of...

    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!

    December 23, 2013 at 3:04 pm

    #1675693

  • RE: Split a variable length string without using a WHILE loop

    check out this thread that has both a scalar and an inline table value function that resolves the same issue: splitting a string on a delimiter into new columns:

    http://www.sqlservercentral.com/Forums/Topic1524275-3077-1.aspx#bm1524325

    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!

    December 23, 2013 at 2:57 pm

    #1675691

  • RE: Memory allocation

    i thinka decent rule of thumb for most SQL installations reserving 1/8th of the memory for the OSand apps, and 7/8ths for SQL server, plus or minus any special needs;...

    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!

    December 23, 2013 at 2:15 pm

    #1675687

  • RE: Insert into table with an identity columns from an other table

    you want to take advantage of the OUTPUT clause, which gives you access to the INSERTED and DELETED triggers that are normally seen inside a trigger;

    here's an example, where 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!

    December 23, 2013 at 12:32 pm

    #1675670

Viewing 15 posts - 2,716 through 2,730 (of 13,460 total)