Forum Replies Created

Viewing 15 posts - 2,311 through 2,325 (of 13,460 total)

  • RE: Advice sought....populating a DEV copy of the database

    here's what i do:

    i script out the DDL differences between the developers' version, and production;

    then i restore a copy of production on dev, and run the script against the database....

    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 23, 2014 at 2:43 pm

    #1716264

  • RE: Left outerjoin and query performance

    TheSQLGuru (5/23/2014)

    What is posted isn't a catch-all query, at least not a typical one. I see no variables in the code posted.

    i'm under the impression that WHERE...

    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 23, 2014 at 10:51 am

    #1716180

  • RE: Left outerjoin and query performance

    what you posted is a catch all query.

    here's an excellent place to start:

    http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

    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 23, 2014 at 9:54 am

    #1716159

  • RE: RUNNING VB.NET APPLICATION WITHOUT INSTALLING SQLEXPRESS ON LOCAL MACHINE

    SQL server runs as a service, so that assumes an install and a lot more.

    for a portable type of application, you'd have to use a portable database; SQL Server Compact,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!

    May 22, 2014 at 10:23 am

    #1715767

  • RE: Concurrency read by .net report application

    by simply changing to using a true temp table, isntead of a permenant table which happens to start with tmp, you could fix your concurrency issue.

    #temp tables are unique 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!

    May 22, 2014 at 5:58 am

    #1715657

  • RE: String question

    well, it's kind of hard, because you have to split the string into parts based on hte ampersand, and then reconstruct the string all over again.

    this would normally be fixed...

    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 22, 2014 at 5:22 am

    #1715645

  • RE: How to insert or update primary key (int) ?!

    the other folks have undoubtedly nailed int; if you needed to migrate those exact values you'd need to use IDENTITY_INSERT and insert the existing values explicitly.

    SET IDENTITY_INSERT NewTable ON

    INSERT INTO...

    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 22, 2014 at 5:06 am

    #1715641

  • RE: Unableto Login from windows\SQL Authentication Both, Admin Locked out

    i suspect that's not the exact sameversion then, my apologies. i assumed it was the same.

    this is the exact version i am using; does this help?

    addselftosqlsysadmin.zip

    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 21, 2014 at 10:56 am

    #1715440

  • RE: Unableto Login from windows\SQL Authentication Both, Admin Locked out

    no find and replace required;

    check the name of the instance, and also make sure the instance is running in services.

    for example, if i go to the services applet in administrative...

    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 21, 2014 at 10:36 am

    #1715433

  • RE: Unableto Login from windows\SQL Authentication Both, Admin Locked out

    this is my go-to script for this issue:

    Login to the server itself, make sure you have local admin rights on the operating system side of things.

    Now simply download and run...

    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 21, 2014 at 9:34 am

    #1715420

  • RE: Create a View where one column is selected from the Previous Row

    quick guess before i get back to work:

    SELECT * FROM #tmp T1 LEFT OUTER JOIN #tmp T2 ON T1.[ROWID] = T2.[ROWID] -1

    and we expect you to provide 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!

    May 20, 2014 at 11:06 am

    #1715053

  • RE: Data Missing In Database

    also, HOW are you checking to see if a function exists or not?'

    if you query sys.objects directly, or are using the SSMS GUI and expecting it to appear there? 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!

    May 15, 2014 at 7:21 am

    #1713839

  • RE: SSRS 2012, how keep multiple spaces (or tabs) on report header, they supressed to single space

    you'll have to find and replace with entities that html does recognize, i think

    SELECT

    REPLACE(

    REPLACE(

    REPLACE(' ...

    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 13, 2014 at 12:01 pm

    #1713190

  • RE: How to use stored procedure to query data in anohter server?

    generally, you create a linked server.

    then your procedure calls the four part name of the object on the other server,

    like this:

    SELECT ID,ColumnList FROM FinanceServer.FinDatabase.dbo.ProductsSoldTable

    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 13, 2014 at 10:23 am

    #1713153

  • RE: Script To permissions

    SSMS assumes you have sysadmin rights on so many things, my knee jerk reaction is "no, not for right click"

    if a developer has VIEW DEFINITION permissions, that's sufficient to 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!

    May 13, 2014 at 10:21 am

    #1713151

Viewing 15 posts - 2,311 through 2,325 (of 13,460 total)