Forum Replies Created

Viewing 15 posts - 9,331 through 9,345 (of 13,460 total)

  • RE: How do I prevent the Windows Administrator Account from viewing my database?

    the bad news: anyone with sysadmin privileges cannot be prevented from reviewing your database, and even if you disabled Windows logins, since he has physical control, he could add himself...

    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!

    May 28, 2010 at 8:39 am

    #1173957

  • RE: HTML Data

    wrong tool for the job.

    reading a web page, entering username and password /submit and browsing to other pages requires some interaction type activities.

    much much better to create an application in...

    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!

    May 28, 2010 at 8:15 am

    #1173939

  • RE: Computed Column

    you had it almost perfect, just needed to remove the stuff between CASE and WHEN

    CREATE TABLE EmployeeResult

    (ERId INT IDENTITY(1,1),

    QuestionNo TINYINT,

    EmpAns CHAR,

    RealAns CHAR,

    Comparison AS

    CASE

    ...

    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!

    May 28, 2010 at 5:48 am

    #1173844

  • RE: Simple scalar function slows down query

    excelent tomas glad it's working for you;

    performance wise, it it the same as the inline calculation you tested against?

    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!

    May 28, 2010 at 5:40 am

    #1173842

  • RE: Opening Internet Explorer Using SQL-CODE

    again, if you explain why you want to open IE thru sql and not other methods we could help you better. detailed info gets detailed answers...vague statements gets vague answers.

    CLR...

    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!

    May 28, 2010 at 4:50 am

    #1173827

  • RE: SQL QUERY PROBLEM

    i formatted your SQL and converted it to use some CTE's;

    look at the final sql and tell us what is not working: how is the data incorrect?

    WITH t2 AS

    ...

    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!

    May 27, 2010 at 6:40 pm

    #1173665

  • RE: Convert Julian date to Gregorian date

    i have a different conversion in my notes: what format are your dates actually in?

    DECLARE @jdate int

    SET @jdate = 109252

    --in AS400/DB2 date is 01/01/1900 + 109 years + 252 days

    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!

    May 27, 2010 at 11:29 am

    #1173482

  • RE: create a stored procedure to create a database

    Dan i poked around the net trying to find out the ramifications of why TRUSTWORTHY on master database might be a bad idea, and it just comes right back...

    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!

    May 27, 2010 at 11:28 am

    #1173480

  • RE: no.of concurrent connections to SQL instance

    run sp_who or sp_who2;

    every spid greater than 50 is a user connection.

    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!

    May 27, 2010 at 10:45 am

    #1173454

  • RE: Trace table inserts/updates

    what value did you put in for the path to the file, N'\\server\folder\Trace',

    if it is not a local directory, but a UNC path, you might have problems depending on...

    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!

    May 27, 2010 at 10:41 am

    #1173452

  • RE: Simple scalar function slows down query

    ok tomas, a couple of things;

    scalar functions can slow things down, as they introduce a hidden cursor/REBAR...million rows=million function calls.

    I've changed your function froma scalar(called once per row) to a...

    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!

    May 27, 2010 at 10:01 am

    #1173428

  • RE: How it matters adding filters in table joins?

    Suresh excellent job on posting a complete example, thanks!

    in this case, you want to compare the actual execution plans to see if it makes a difference.

    in your example, they produce...

    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!

    May 27, 2010 at 9:25 am

    #1173405

  • RE: query on old employee table

    another way without the UNION:

    select

    CASE

    WHEN manager='Y'

    THEN 1

    ELSE 2

    END

    as myorderBy,name,salary

    from sometable

    ORDER...

    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!

    May 27, 2010 at 9:14 am

    #1173394

  • RE: Opening Internet Explorer Using SQL-CODE

    oh yeah we are on the same page. there's another thread on CLR that got me all excited becasue i got it to work to read a web 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!

    May 27, 2010 at 9:06 am

    #1173384

  • RE: query on old employee table

    select 1 as myorderBy,name,salary from sometable where manager='Y'

    UNION ALL

    select 2 as myorderBy,name,salary from sometable where manager='N'

    ORDER BY myorderBy,salary

    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!

    May 27, 2010 at 9:00 am

    #1173375

Viewing 15 posts - 9,331 through 9,345 (of 13,460 total)