Forum Replies Created

Viewing 15 posts - 7,906 through 7,920 (of 13,460 total)

  • RE: If you could stop working tomorrow, would you still do SQL?

    Ever since I won the lottery, the only reason I hang out around here is so I can have friends....

    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!

    March 21, 2011 at 8:26 am

    #1301331

  • RE: query to retrieve only 5 hours data for current day

    try to avoid fields having the same name as their datatype; use a name that is more descriptof the purpose... like "entryDate" or whatever the field might mean to you.

    when...

    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!

    March 21, 2011 at 5:44 am

    #1301202

  • RE: SQL Statement for Compatibility Check

    and to change compatibility in SSMS so you can test a specific statement:

    ALTER DATABASE [SandBox] SET COMPATIBILITY_LEVEL = 80

    GO

    SELECT IDENTIFICATION, CREATE_DATE, CREATE_USER FROM CUSTOMER

    GO

    ALTER DATABASE [SandBox] SET COMPATIBILITY_LEVEL = 90

    GO

    SELECT...

    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!

    March 18, 2011 at 11:45 am

    #1300706

  • RE: Is there any way to create a temp table on the remote server via OpenQuery?

    sweet! glad that worked for you; I'm putting that in my notes that it really works; i wasn't absolutely sure.

    yeah, getting the syntax for the dynamic sql part can 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!

    March 18, 2011 at 8:32 am

    #1300538

  • RE: read sqlserver trace file

    easiest way is from within SSMS via TSQL for me; the trace file will be open as if it were a table:

    you might need to do select * from sys.traces...

    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!

    March 18, 2011 at 6:22 am

    #1300436

  • RE: Monitore used databases

    in SQL 2000(the forum you posted in), i think it's a little tougher;

    the easiest way to be to set up a trace on the server and check that after letting...

    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!

    March 17, 2011 at 3:13 pm

    #1300251

  • RE: Importing Indexes from one Server to another

    take a look at the posts in this discussion; it has a community contribution to script all indexes as CREATE INDEX statementing:

    http://www.sqlservercentral.com/Forums/FindPost1079779.aspx

    as far as the GUI goes, i think you...

    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!

    March 17, 2011 at 9:21 am

    #1300006

  • RE: Script all indexes as CREATE INDEX statements

    wow this script has come a long way since the original version; thanks again to everyone who has contributed;

    I cleaned up the formatting a little bit and added some comments,...

    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!

    March 17, 2011 at 9:17 am

    #1299999

  • RE: Problem with over 255 Chars per column in textfile-export with INSERT INTO OPENROWSET

    there is an additional caveat with that; when the driver scans the source for the rules on IMEX=1, it looks at the first 8 rows to decide the data size...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!

    March 17, 2011 at 8:37 am

    #1299970

  • RE: Problem with over 255 Chars per column in textfile-export with INSERT INTO OPENROWSET

    i believe this is a well known issue i'd seen with importing/exporting to excel or text files via the jet data providers. To overcome, you have to set 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!

    March 17, 2011 at 6:03 am

    #1299883

  • RE: Ordering of tables based on data output...possible?

    do you have a userId/name that is inherited fromt eh page you can use as a parameter? then you can order the data:

    ORDER BY

    CASE

    WHEN SomeTable.AnalystID =...

    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!

    March 16, 2011 at 3:02 pm

    #1299673

  • RE: sproc calling xp_cmdshell invoking vbs to set column properties in Excel

    i think the domain account needs to have launched excel at least once manually on the server itself, right?

    the first time excel launches for a user, if there are not...

    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!

    March 16, 2011 at 2:18 pm

    #1299641

  • RE: Property Owner is not available for Database - root cause?

    On a related note, I think this is how to check my current databases to see if any are owned by anyone other than sa, correct? so this doesn't occur...

    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!

    March 16, 2011 at 1:59 pm

    #1299634

  • RE: Use sp_OACreate to connect to share drive ..

    i have this saved in my snippets on how to map a drive from xp_cmdshell:

    exec master.dbo.xp_cmshell 'NET USE G: \\UNCPath\d$ /user:domain\user password'

    GO

    RESTORE Database DBName FROM Disk = 'G:\PAth to bak'

    GO

    EXEC...

    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!

    March 16, 2011 at 12:52 pm

    #1299598

  • RE: want funstion

    Lynn on my roughly half a million row table i created with the data below, i get roughly double the performance with ITV vs scalar;16 seconds vs 9 seconds.

    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!

    March 16, 2011 at 12:05 pm

    #1299556

Viewing 15 posts - 7,906 through 7,920 (of 13,460 total)