Forum Replies Created

Viewing 15 posts - 10,861 through 10,875 (of 13,460 total)

  • RE: Entry level Questions

    some of the hobby databases that I've done in the past , to help me really understand SQL:

    1. gathering lists of city/county/state/zipcode, and breaking them up into parent-child tables:...

    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!

    July 9, 2009 at 9:34 am

    #1022498

  • RE: Scripts to create AdventureWorks

    i backed it up and put it on the web if you want it;

    see the post here:

    http://www.sqlservercentral.com/Forums/Topic750105-338-1.aspx

    this errors on the forum causing multi posts is annoying.

    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!

    July 9, 2009 at 8:51 am

    #1022441

  • RE: Entry level Questions

    if you can spare the time, dump a request to some local businesses asking for an unpaid intern position sitting with their SQL DBA. volunteering a few hours 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!

    July 9, 2009 at 7:55 am

    #1022373

  • RE: Scripts to create AdventureWorks

    here you go jason:

    i don't think the msi works unless you have SP2a or above installed;

    i ran the msi, which drops an mdf/ldf pair in the default data folder so...

    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!

    July 9, 2009 at 7:47 am

    #1022364

  • RE: script for Checking database online or not

    that's an easy one for SQL 2005, mohan;

    one of the sys views has exactly what you are looking for;

    select state_desc,* from sys.databases

    the state_desc is usually ONLINE or OFFLINE, but there...

    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!

    July 9, 2009 at 7:21 am

    #1022345

  • RE: Where to put shared Code? Whats your opinion?

    at our shop, we stick useful udf's and procedsures in the model database; everyone(well developers) knows where they are if they need to copy them to a newly restored...

    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!

    July 9, 2009 at 7:12 am

    #1022334

  • RE: Scripts to create AdventureWorks

    it's a downloadable msi, which attaches an mdf i think; ; too big to actually script out

    here's a link to 2005 databases:

    http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004

    and here's a link to the base page for...

    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!

    July 9, 2009 at 6:17 am

    #1022300

  • RE: Lock and Unlock Tables

    there's two ways I can think of to interpret "lock the table", which is why we ask.

    you can "lock the table" with permissions, so noone, or noone but an sysadmin...

    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!

    July 9, 2009 at 6:05 am

    #1022290

  • RE: Getting all identity values in a batch insert statement.

    there is an optional OUTPUT clause you can use to retrieve all the values that were inserted; typically you insert the output into a temp table and use it for...

    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!

    July 8, 2009 at 3:08 pm

    #1021955

  • RE: How to decode Timestamp in SQL

    timestamp is a misnomer; the proper datatype is actually rowversion;

    it is NOT related to time in any way, it is just a unique number which is created/updated automaticall when an...

    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!

    July 8, 2009 at 3:01 pm

    #1021944

  • RE: Insert a distinct number into a table with an Identity Column

    i think your issue is the NOT EXISTS...

    whenever you do that, You have to test for nulls, as that will screw up the EXISTS

    WHERE NOT EXISTS

    (SELECT OldLicenseNumber 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!

    July 8, 2009 at 9:41 am

    #1021811

  • RE: Restriction in the number of records updated

    another way to consider is to take away access to the tables themselves, and only grant access via stored procedures.

    then you simply make sure the stored proc will execute onyl...

    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!

    July 8, 2009 at 9:35 am

    #1021800

  • RE: Add column at ordinal position programmatically

    OK matthew; here's two versions for you, one for 2000, another for 2005;

    as you'd guess, the 2000 version gets truncated if you have a huge table definition of 8000 or...

    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!

    July 8, 2009 at 8:13 am

    #1021672

  • RE: What?? Full defrag on a Sql Production box...

    ahh, now if the defrag is introducing problems, yeah, I see your point;

    Any chance you can reschedule either the defrag or the backup so they don't intersect at the same...

    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!

    July 8, 2009 at 6:13 am

    #1021590

  • RE: What?? Full defrag on a Sql Production box...

    Steve, for my shop, we also believe it is a good idea to defrag at the OS level; most machines are scheduled for once a week, and my dev machine...

    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!

    July 8, 2009 at 5:16 am

    #1021565

Viewing 15 posts - 10,861 through 10,875 (of 13,460 total)