Forum Replies Created

Viewing 15 posts - 12,781 through 12,795 (of 13,460 total)

  • RE: Possibly complex SQL

    really difficult without the schema of the tables...can we assume that the table CitrixApps, with only a single column, is source for the values in the Working table's Application1/2/3... columns?

    if...

    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!

    January 16, 2007 at 6:39 am

    #683452

  • RE: Creating views under INFORMATION_SCHEMA in SQL 2005

    that's not true; I've created lots of information_schema views in sql 2000;

    like Peter outlined, you simply create a view in master and change the owner to INFORMATION_SCHEMA; I've done...

    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!

    January 16, 2007 at 5:17 am

    #683434

  • RE: Need comparison details between Veritas Agent for MS SQL Server and SQL litepeed

    as I understand it, SQL Lite speed uses the updated SQL Server API's to create a standard SQL Server backup, abiet much faster, because the TSQL/Enterprise Manager backup commands use...

    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!

    January 15, 2007 at 2:07 pm

    #683349

  • RE: tempdb wont shrink

    what is the defined size of the tempdb? tempdb gets recreated every time you stop and start the server, so if you stoip and start, and it is still 5...

    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!

    January 15, 2007 at 10:24 am

    #683300

  • RE: How to automate script after every backup/restore in SQL Server 2k ?

    there's no event you can use, but you can check to see if soemthing has been backedup since a certain date, and do your special process from there (i assume...

    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!

    January 15, 2007 at 10:19 am

    #683299

  • RE: EM running extremely slow ....

    you didn't explain what you meant by "slowness"... I still suspect the autoclose issue;

    you can run this statement to see if anything is set to autoclose=true or not:

    SELECT + [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!

    January 15, 2007 at 9:48 am

    #683288

  • RE: Changed from CHAR to VARCHAR, MDF increased in size?

    you'll want to dbcc reindex the database now. basically the space that was used by the char fields is still there, and new space was added for the varchars....the system...

    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!

    January 13, 2007 at 12:16 pm

    #683096

  • RE: how to know counts of field usage in a table

    You could test how many fields are empty, ie  null/not null, but not how of often they are used.

    when SQL inserts or updates a row, no statistics are available wether...

    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!

    January 12, 2007 at 2:41 pm

    #683059

  • RE: Can multiple CPUs cause Primary Key Violations?

    Correct me if I'm wrong, but the blocker script is an example of what happens when you have high volume inserts, right?  I've read that the identity() column can have...

    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!

    January 12, 2007 at 2:33 pm

    #683057

  • RE: EM running extremely slow ....

    by slow you mean it takes a long time for EM to display the list of databases?

    If that is true, then it's a known issue where if each database 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!

    January 12, 2007 at 2:16 pm

    #683053

  • RE: How Can I Create Notifications When a Trigger is Run

    here's teh puedocode that I currently use for something similar:

    add one more column to your tracking table, a flag or field to signify "NotificationSent' or something.

    now create a job 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!

    January 12, 2007 at 6:34 am

    #682885

  • RE: How to change computer name in SQL 2005

    there is no change for the users; remember that their logins and permissions are mapped to roles in each of databases on the machine. Esentially their permissions are stored in 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!

    January 12, 2007 at 5:00 am

    #682857

  • RE: Get latest record without timestamp

    without more information, I don't believe you can.

    is there an identity column in the tabe? is there a datetime field for creation or updated?

    if the primary key might be (Accountno,AdmissionReason), 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!

    January 11, 2007 at 9:54 am

    #682725

  • RE: Script for aliases

    i looked at sp_addalias, and it looks like any users that are aliased as dbo would have the sid for sa/dbo (which is always 1):

        -- INSERT SYSUSERS 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!

    January 11, 2007 at 9:35 am

    #682723

  • RE: How to change computer name in SQL 2005

    there's a difference between changing a machine name, and changing a named instance.

    for example, if my machine is named DEVPLATFORM, and I want to rename it as DEVELOPER, I right...

    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!

    January 11, 2007 at 6:35 am

    #682664

Viewing 15 posts - 12,781 through 12,795 (of 13,460 total)