Forum Replies Created

Viewing 15 posts - 3,271 through 3,285 (of 13,460 total)

  • RE: IP Address Doesnt turn from offline to online

    you didn't mention if you followed HanShi's advice about pinging all the ip addresses you think you want to use for your cluster; it really does sound like somethign has...

    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!

    June 17, 2013 at 9:33 am

    #1624656

  • RE: How to find dependencies in dynamic sql queries

    ksatpute123 (6/17/2013)

    I think it is far fetched because after searching the internet for days I found nothing.

    I want to find out all the object referring the columns in a table....

    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!

    June 17, 2013 at 7:38 am

    #1624587

  • RE: get set of random rows with distinct values

    by introducing a row_number function that partitions by the two columns, you cna find unique rows; fromt here, it's just the same query you had before, but hitting a subquery...

    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!

    June 17, 2013 at 5:39 am

    #1624549

  • RE: script in sql server 2008 for generating .ndf files

    mca.deepak3335 (6/17/2013)

    can any one give me script for generating .ndf files in sql server 2008

    did you mean scripting existing files?

    fastest way i think would be to right click 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!

    June 17, 2013 at 5:29 am

    #1624548

  • RE: generate scripts in sql server

    Almost everything in scripting is configurable as to whether a result is scripted or skipped;

    spend some time reviewing the many scripting options that are in Tools>>Options;

    As I remember, scripting 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!

    June 17, 2013 at 5:23 am

    #1624547

  • RE: Critique - SQL Saturday Abstracts

    Great Sam! which SQL Saturday is this for? i know there is a local(for me) in the Fort Lauderdale area coming up in three weeks or so; I was wondering...

    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!

    June 14, 2013 at 1:04 pm

    #1624257

  • RE: Performance DIES when REMOVING Where Clause

    first thing i see is the non-Sargable WHERe statemnet in the first CTE:

    cteMain is not Sargable:

    WHERE (DATEDIFF(d, g.HireDate, GETDATE()) > 181

    i think this is the equivilent, and would 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!

    June 14, 2013 at 11:53 am

    #1624233

  • RE: ***Restore multiple sql databases***

    hydbadrose (6/14/2013)

    I have about 100 db's with mdf, ldf, and ndf files that I need to restore to the SQL 2008R2 on different instance. I have all the backups 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!

    June 14, 2013 at 10:16 am

    #1624189

  • RE: ?? on xp_cmdshell not writing to file

    I see the issue now.

    bcp cannot take any input with carriage return line feeds.

    your statement is easy to read, because it has the CrLf in it, but i'ts not valid...

    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!

    June 14, 2013 at 7:32 am

    #1624111

  • RE: ?? on xp_cmdshell not writing to file

    probably permissions; when you go outside of a database, like to the command line, a user you do not expect(the startup account of the service) is used

    does this code return...

    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!

    June 14, 2013 at 6:57 am

    #1624085

  • RE: image insertion into database

    Ed Wagner (6/14/2013)

    I've always done this using a .NET application and found it far easier than trying to force it with T-SQL. The first big hurdle in doing it...

    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!

    June 14, 2013 at 6:49 am

    #1624082

  • RE: image insertion into database

    gurjer48 (6/14/2013)

    how to add and retrieve a image to and from databse table using open rowset(exaplain)?

    is there any other ways of doing image insertion and retrieval?

    Thanks and Regards

    this post has...

    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!

    June 14, 2013 at 5:43 am

    #1624048

  • RE: Work out 2nd, 3rd, 4th Puchases

    here's my best guess, based on your original query, using row_number() like kingston suggested:

    SELECT

    ROW_NUMBER() OVER (PARTITION BY mem.MemberID ORDER BY t.TransactionDate) AS RW,

    mem.MemberID,

    mem.FirstName + ' '...

    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!

    June 14, 2013 at 5:27 am

    #1624043

  • RE: inserting a zip file into a varbinary column in a database

    usually this is done in a programming language, as there's a lot more tools and control there.

    Doing it in TSQL only, the file has to exist, and you have 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!

    June 13, 2013 at 12:19 pm

    #1623851

  • RE: My row_number() is misbehaving or I'm an not a smart man

    Ed you are correct, i'm still not getting what i'm after;

    if i add these five more rows to my sample data above, i would expect five values with [1] and...

    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!

    June 13, 2013 at 6:26 am

    #1623664

Viewing 15 posts - 3,271 through 3,285 (of 13,460 total)