Forum Replies Created

Viewing 15 posts - 3,436 through 3,450 (of 13,460 total)

  • RE: Check values whic are not Decimals

    greeshatu (5/20/2013)

    Hi ..

    I have a Column 'X' NVARCHAR(10) in Table 'X' which is mapped to Column 'Y' Decimal(23,10) of Table 'Y'

    I want to check in Table 'y' which are...

    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, 2013 at 5:07 am

    #1616576

  • RE: Using an ASP

    jayoub1 (5/17/2013)

    I am a total newbie and have a question to ask. I am the only DBA on a team managing several SQL servers and we have a new...

    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 17, 2013 at 12:24 pm

    #1616319

  • RE: Trigger worked in 2008, but not in 2008 R2

    Agreed the error about the profile is the giveaway about database mail.

    take a look at this thread and solution i posted a while ago to Script Out your database mail...

    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 17, 2013 at 12:14 pm

    #1616316

  • RE: How to delete a record with different column values?

    if DecId is an identity() column, can can infer that if the data was ordered by DecId, only the last record applies;

    Since this looks a lot like homework, I'll give...

    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 17, 2013 at 10:12 am

    #1616249

  • RE: orders over more than one partition question.

    partitioning the data, just by itself, does not mean the queries hitting it will be faster;

    only on the queries where the optimizer determines that all the data required is all...

    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 17, 2013 at 10:07 am

    #1616247

  • RE: Block reporting from a database

    MichaelDep the problem with a logon trigger is it hits them with a hammer without regard to which database, so if both the OLTP and the reporting database is 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 17, 2013 at 9:01 am

    #1616221

  • RE: Check values whic are not Decimals

    select * from YourTable

    where FLOOR(YourDecimalColumn) = YourDecimalColumn --can be converted to an int without data loss

    AND YourDecimalColumn < 2147483647 --max size of an int

    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 17, 2013 at 6:59 am

    #1616157

  • RE: Check values whic are not Decimals

    your not real clear on the question;

    if the column is typed as (23,10), then every non-null value is a decimal, by definition;

    so do you mean which values are null?

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

    May 17, 2013 at 6:56 am

    #1616152

  • RE: Intelisense is not working !!! Even After trying everything mention on msdn website

    ok, it's possible if you newly created or attached a database, it might not be in the intellisense cache;

    usually it gets rebuilt on connecting to a server, but in SSMS...

    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 17, 2013 at 6:53 am

    #1616150

  • RE: Adding LinkedServer in Uppercase and Lowercase

    you'll need to add them with different names, because your collation is non-case sensitive in the master database;

    you could rebuild the server with a case sensitive collation, but that...

    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 17, 2013 at 6:00 am

    #1616132

  • RE: Is it possible to remove "public" role for database user ?

    no ;

    the public role is kind of like the "Everyone" group in Active directory;

    it's required for the system to work, everyone belongs to it. it cannot be removed.

    you can, hoever...

    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 17, 2013 at 5:35 am

    #1616123

  • RE: Order by SP_SEND_MAIL

    your issue is from the union of the query;

    the aliases for column names always come from the first query in the union, and right now all the columns have...

    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 17, 2013 at 5:29 am

    #1616121

  • RE: nolock

    gchappell (5/16/2013)

    Has nolock been depricated in SQL Server 2012, or does the optimizer ignore the no lock and still run?

    nolock is always ignored for insert/update delete statements, as honoring that...

    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 16, 2013 at 12:58 pm

    #1615970

  • RE: update statement - what's the locking/blocking risk?

    a very basic model to help you visualize the process:

    SET ROWCOUNT 50000

    WHILE 1 = 1

    BEGIN

    UPDATE dbo.myTable

    SET MyField...

    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 16, 2013 at 12:16 pm

    #1615953

  • RE: Restore with Replace, but keep old views?

    well, it's going to be an extra/separate process to save the view definitions, but you could at least automate it;

    for example, you could guard all the view definitions, restore, then...

    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 16, 2013 at 12:02 pm

    #1615945

Viewing 15 posts - 3,436 through 3,450 (of 13,460 total)