Forum Replies Created

Viewing 15 posts - 4,216 through 4,230 (of 13,460 total)

  • RE: how to find name of a table which has maximum number of transactions for a large database

    anthony.green (12/18/2012)

    I was always told to not trust the sys view as it can differ from what was in the table, that was back in SQL 2000 days so unsure...

    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 18, 2012 at 10:48 am

    #1569684

  • RE: HOW TO TABLE DATA VALUE CHANGES MANUALLY DONE BY A PERSON

    stating the obvious here, you should immediately remove that persons access to SQL server, and change the sa /other admin passwords.

    make sure whatever application that is used to connect does...

    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 18, 2012 at 8:56 am

    #1569633

  • RE: how to find name of a table which has maximum number of transactions for a large database

    another way to get your row counts; the indexes have the rowcounts built into the sys view:

    --for 2005/2008:

    Select OBJECT_NAME(object_id) as TableName,SUM(rows) as NumRows,index_id

    From sys.partitions p

    ...

    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 18, 2012 at 8:54 am

    #1569630

  • RE: modify proc creates odd script

    you can turn off the sp_execute scripting, so it's a cleaner CREATE / ALTER PROCEDURE.... by changing a flag the flag "Include IF NOT EXISTS Clause" in the scripting...

    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 18, 2012 at 8:24 am

    #1569607

  • RE: HOW TO TABLE DATA VALUE CHANGES MANUALLY DONE BY A PERSON

    safzalhussain (12/18/2012)

    we have a database of attandance system in which daily attendance recorded. there is a table in which one of IT guy directly modify his record for his late...

    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 18, 2012 at 7:41 am

    #1569574

  • RE: DBCC CHECKDB Error?

    GilaMonster (12/18/2012)

    I recommend restoring from the last good full backup. Since the DB is in simple recovery model, that amount of data loss (since the last full backup) must 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!

    December 18, 2012 at 6:21 am

    #1569527

  • RE: Detecting Detached Databases

    Jack 95169 (12/18/2012)

    Nearly...

    You need to enable XP_cmdshell beforehand

    I've also done a bit of tidying up

    wow Jack you replied to a ten year old thread!

    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 18, 2012 at 6:06 am

    #1569516

  • RE: How to install an oracle linked server on SQL Server 2008 r2 failover cluster manager

    it starts out pretty much like every other desktop install around the office that is connecting to Oracle.

    Use the oracle universal installer to install the client tools. See your 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!

    December 17, 2012 at 3:34 pm

    #1569302

  • RE: how to get calculate data based on other column in same table

    well my colA and ColB resulsts seem to Me to be correct;

    your expected results for ColB, where it's supposed to be by rank, doesn't match the data, i think.

    ColC 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!

    December 17, 2012 at 2:26 pm

    #1569287

  • RE: how to find ASCII characters in a table?

    mkarthikeyyan 89837 (12/17/2012)

    Hi,

    Please help to solve this !!!

    i need to create tables and insert values in following tables, the scenario is

    create table tbl1(tbl1_col1 int primary key ,tbl1_col2 int)

    create table tbl2(tbl2_col1...

    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 17, 2012 at 1:17 pm

    #1569260

  • RE: 2012 Management Console

    for the other direction, when you have the full SSMS and you connect to a lesser isntance, it varies based on what you connect to; i have 2012 developer installed,...

    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 12, 2012 at 3:31 pm

    #1568085

  • RE: Query for a plus sign

    CELKO (12/11/2012)

    In COBOL, the display and the internal format of data was the same. Each field had a PICTURE clause to define it. Your question makes sense only in 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!

    December 12, 2012 at 11:29 am

    #1568019

  • RE: Query Problem

    as suggested: changinbg old style join to new style ansi JOIN..ON:

    SELECT

    tblTransactions.PO_Number,

    tblTransactions.PO_Date,

    tblTransactions.Quantity,

    tblTransactions.Software_Description,

    tblTransactions.Unit_Price,

    tblTransactions.SoftwareShortName,

    tblTransactions.Transaction_Number,

    tblTransactions.Transaction_Type,

    tblBulkPurchases.Quantity_Remaining,

    ...

    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 12, 2012 at 9:32 am

    #1567972

  • RE: Delete trigger

    Stuart what is the relevance of this WHERE statement coming from?

    WHERE ttask.id = 23

    are you only capturing queries that match a certain task type?

    it looks to me like that 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!

    December 12, 2012 at 8:30 am

    #1567918

  • RE: How to notify through DB MAIL when sql server agent stopped automatically?

    Chris Harshman (12/12/2012)

    The problem is that SQL Agent is the program you'd typically use to do monitoring and alerting. It sounds like what you really need is some kind...

    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 12, 2012 at 8:20 am

    #1567911

Viewing 15 posts - 4,216 through 4,230 (of 13,460 total)