Forum Replies Created

Viewing 15 posts - 4,591 through 4,605 (of 13,460 total)

  • RE: how to read trace table

    it's fairly easy.

    first, doa SELECT * FROM sys.traces; you'll probably see traceid = 1(the default trace) plus any other traces you have created (2,3,4 etc)

    select the trace id of...

    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!

    October 15, 2012 at 12:11 pm

    #1549247

  • RE: Extracting Data from single table

    i think a simple test with an EXISTS and correlated subquery will get you want you want:

    With YOURTABLE (TICKET,STATUS)

    AS

    (

    SELECT 9543,1 UNION ALL

    SELECT 9543,5 UNION ALL

    SELECT 9543,5 UNION...

    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!

    October 15, 2012 at 11:47 am

    #1549240

  • RE: uninstall default instance

    i think it might be easier to jsut change the default paths for the files and backups, wouldn't it?

    I did basically what you are saying to another server recently;

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

    October 15, 2012 at 11:32 am

    #1549232

  • RE: split column pipe delimited

    ok here's one solution:

    ALTER FUNCTION dbo.fn_parsename

    (

    @pString VARCHAR(7999),

    ...

    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!

    October 15, 2012 at 10:06 am

    #1549188

  • RE: Active Directory Groups

    ron there's a built in extended procedure that can tell you what Ad groups an AD login belongs to.

    the problem is, you do NOT want to grant everyone access to...

    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!

    October 15, 2012 at 9:57 am

    #1549184

  • RE: Best way to insert a lot of data in a database

    let us know if we can help with the additional issues you are encountering; glad i could get you pointed in a helpful direction.

    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!

    October 15, 2012 at 7:37 am

    #1549127

  • RE: Deplying CLR Stored procedure

    additinally, since you've deployed it on one server already, you can actually script them out as a binary blob and install them via a script...the script may load slow 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!

    October 15, 2012 at 6:09 am

    #1549083

  • RE: Re: Ticket- MSSql server is in other than Active state

    sounds like an end user comment...it's not an actual error message.

    I would guess that someone could not connect or was blocked, and stated that the server must be down, which...

    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!

    October 12, 2012 at 11:38 am

    #1548783

  • RE: Foreign Key referencing a column with no unique index or constraint

    i tried to duplicate this, and couldn't drop any unqiue constraints because of the foreign keys.

    is it possible that the database was originally a SQL 2000 database?

    in that case, becasue...

    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!

    October 12, 2012 at 9:29 am

    #1548726

  • RE: T-SQL Coding Help

    Jeff Moden (10/11/2012)

    I believe the following will do as you ask. I call it a "data smear" (because it "smears" the largest value "down" through the returned rows) 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!

    October 12, 2012 at 8:56 am

    #1548702

  • RE: Get count depending on specific criteria

    here's a CTE of your data that is inte ready-to-use format my friend Cadavre suggested:

    WITH myCTE ([Branch],[Year],[Count of All who failed],[Count of all right handed who failed])

    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!

    October 12, 2012 at 8:11 am

    #1548662

  • RE: VS 2010 DB Project crashing on Copy/Paste

    how much memory does your developer machine have?

    I find VS2010 is very resource intensive; a single isntance devenv.exe is currently 1.4 gig or ram for a big project, and two...

    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!

    October 12, 2012 at 7:54 am

    #1548651

  • RE: UDF Performance When Used As A "Macro"

    well, ideally, your scalar UDF can be converted to an inline table funciton instead.

    Create FUNCTION fnAdjustDateTime_itv (@date datetime, @timezone int)

    RETURNS table

    AS

    RETURN

    SELECT DateAdd(hh,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!

    October 12, 2012 at 7:37 am

    #1548637

  • RE: Best way to insert a lot of data in a database

    bulk insert expects raw data, and not formatted INSERT...statements.

    if your file looked like this isntead:

    1,Apr 27 2012 12:00AM

    2,Apr 27 2012 12:00AM

    bulk insert would insert into a two column table witht...

    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!

    October 12, 2012 at 7:23 am

    #1548627

  • RE: How to monitor a Production Database in SQL Server 2005

    Monitoring can be a wide subject, sicne there is a lot of different things you might want to review.

    redgate, the website sponsor/owner, provides some free reports you can add to...

    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!

    October 12, 2012 at 5:30 am

    #1548563

Viewing 15 posts - 4,591 through 4,605 (of 13,460 total)