Forum Replies Created

Viewing 15 posts - 2,806 through 2,820 (of 13,460 total)

  • RE: Redgate SQL Compare Permissions

    http://www.red-gate.com/SupportCenter/content/SQL_Compare/knowledgebase/SC_Permissions_Required

    VIEW DEFINITION and VIEW SERVER STATE are what's recommended, it looks like; otherwise you get data filtered based on what schema/objects you CAN see.

    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!

    December 10, 2013 at 3:11 pm

    #1672461

  • RE: Is there a way to do this with lag in 2012 or without Temp tables in 2008?

    it took me a while just to massage your sample data into a usable format.

    i ran out of gas just getting this data consumable, maybe someone else can run teh...

    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!

    December 10, 2013 at 3:08 pm

    #1672459

  • RE: Encryption and Decryption data From DB level in SQL

    the zero-changes to the application thing is the tough part;

    i know it's possible to use certificates to allow a view to decrypt data, and then i assume you could...

    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!

    December 10, 2013 at 2:53 pm

    #1672453

  • RE: Finding the MIN and MAX date - How do I approach this?

    Luis Cazares (12/10/2013)

    Lowell (12/10/2013)

    if you group by both EMPID and PrimaryRater, you don't get the "end Date" you were looking for according to your sample data, so im not sure...

    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!

    December 10, 2013 at 2:12 pm

    #1672439

  • RE: Problem excecuting store thats return multiple result sets

    basically, you assign the results to a DataSet; since a DataSet contains a collection of DataTable,s you can then iterate through each datatable, or assign, say a grid's datasource 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!

    December 10, 2013 at 1:37 pm

    #1672431

  • RE: Finding the MIN and MAX date - How do I approach this?

    well, whenever you use any of the aggregate functions(MIN,MAX,COUNT)

    you have to have one or more GROUP BY column(s).

    IF you group by just EMPID, you can only end up getting...

    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!

    December 10, 2013 at 1:31 pm

    #1672429

  • RE: Encryption and Decryption data From DB level in SQL

    typically what i've done in the past is to limit access to the table to require stored procedures.

    the stored procedures get signed, so they can be called by other...

    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!

    December 10, 2013 at 12:06 pm

    #1672408

  • RE: replace null or empty values with default date

    asranantha (12/10/2013)

    its not given exacetely results and doj format data 0 not added .

    2/23/211...

    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!

    December 10, 2013 at 8:01 am

    #1672329

  • RE: replace null or empty values with default date

    based on your response, i guess you cannot consider fixing the datatype.

    here's an example based on your sample data;

    the column BackToFormattedDate is what you are asking for

    ;WITH MyCTE([id],[name],[doj])

    AS

    (

    SELECT '1','abc','3/1/2011'...

    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!

    December 10, 2013 at 7:23 am

    #1672306

  • RE: Full Text Index / Contains

    wouldn't switching to a union work, i think? i think the AND would short circuit any table scan right away, and will perform a bit better.

    SELECT

    *

    FROM ...

    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!

    December 10, 2013 at 7:12 am

    #1672303

  • RE: replace null or empty values with default date

    first, a reminder: ALWAYS STORE DATES AS DATES.

    from your sample data, it looks like you are storing as varchars, and converting varchars to dates and then dates to varchars introduces...

    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!

    December 10, 2013 at 6:45 am

    #1672296

  • RE: will Collocation help in following situation.

    the answer is no, then.

    speeding up of the queries will require indexing changes /additions based on the common WHERE statements being used;

    partitioning for performance, like Gail mentioned, is WAY 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!

    December 10, 2013 at 6:08 am

    #1672280

  • RE: Unable to view databases according to user login

    azadrazvis (12/10/2013)

    Hi

    I am trying to create logins for multiple windows users to login in to sql server 2012 but after creation of login and database user...

    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!

    December 10, 2013 at 6:04 am

    #1672278

  • RE: error 15284 when trying to drop user

    this is the query i use for defining object ownership:

    ;with objects_cte as

    (

    select

    o.name,

    ...

    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!

    December 9, 2013 at 2:49 pm

    #1672138

  • RE: Server Security

    you could add a serverwide DDL trigger that watches for drop database, and issue a rollback command.

    that would not prevent a sysadmin from disabling said trigger, nor from restore 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!

    December 9, 2013 at 12:52 pm

    #1672107

Viewing 15 posts - 2,806 through 2,820 (of 13,460 total)