Forum Replies Created

Viewing 15 posts - 1,396 through 1,410 (of 1,838 total)

  • RE: Always Abstract

    Craig-315134 (8/21/2013)

    ... I favour moving as much application business logic into stored procedures as is possible, thereby abstracting out the UI layer from the business logic. And our shop uses...

    August 21, 2013 at 10:53 am

    #1643539

  • RE: How to Compile, Deploy and Consume a SQL Server CLR Assembly

    Jeff Moden (8/13/2013)

    Outstanding step by step article but (to cover the headline) I'm pretty sure that encryption and decryption Is possible in SQL Server. 🙂

    While it's possible to encrypt data...

    August 13, 2013 at 9:58 am

    #1641029

  • RE: The Standard Limitation

    Andrew-H (8/7/2013)

    DB Software licensing is a strange thing. Imagine if car companies ran business like software companies, charging you extra if you added a bunch of performance parts after...

    August 7, 2013 at 11:00 am

    #1639481

  • RE: The Standard Limitation

    GPO (8/7/2013)

    Wouldn't it be good if they created a licensing structure that forced db designers to normalise their OLTP databases properly. I'm heartily sick of people going on about how...

    August 7, 2013 at 10:58 am

    #1639480

  • RE: Could You Live Like a DBA?

    jjeffryes (7/26/2013)

    That was amusing. I expecially liked "Scans." Life is like that.

    Of course you realize that it would be more efficient to build your pantry clustered index based on a...

    July 26, 2013 at 10:18 am

    #1636235

  • RE: What Counts for a DBA: Laziness

    I agree with the editorial. After all, if I had to manually do things on each of my dozen servers every day, I'd be more likely to miss one...

    March 25, 2013 at 10:07 am

    #1600387

  • RE: Generate Script

    What might be a better way to do it is using the Object Explorer Details window in Management Studio. If you click on the Databases folder in Object Explorer,...

    March 15, 2013 at 7:18 am

    #1597482

  • RE: Can Someone Explain These Wait Times to Me?

    I actually record the wait stats on my main OLTP instance into a special DBA only database and reset them every hour. After about 2 and a half years...

    March 15, 2013 at 6:30 am

    #1597465

  • RE: Re-Index :Performance ISSUE

    To know if blocking was the issue, you would have had to check the running requests using sys.dm_exec_requests or look for waiting locks in sys.dm_tran_locks before you stopped the job....

    March 15, 2013 at 6:16 am

    #1597460

  • RE: Recommended index causing query to run twice as long / HASH vs NESTED LOOP

    Adam Bean (3/14/2013)

    ...is there any other better way to handle date aggregates outside of using a date table? I've always been so used to simply adding the date part functions...

    March 14, 2013 at 9:41 am

    #1597096

  • RE: Recommended index causing query to run twice as long / HASH vs NESTED LOOP

    Adam Bean (3/13/2013)

    ...curious if either of you have any feedback on why the major difference. My assumption at this time is really the order of the columns on the index....

    March 13, 2013 at 3:39 pm

    #1596734

  • RE: Grant persmissions to database

    sqlfriends (3/13/2013)...when granting execute on schema, what does execute mean?

    execute stored procedures,

    how about functions and triggers etc?

    Thanks

    EXECUTE privilege is for stored procedures and scalar functions

    SELECT privilege would be for...

    March 13, 2013 at 1:50 pm

    #1596693

  • RE: Recommended index causing query to run twice as long / HASH vs NESTED LOOP

    Grant Fritchey (3/13/2013)

    What I meant was store the Month & Day values as those, either during the insert/update process or as calculated columns. Performing functions on columns in any kind...

    March 13, 2013 at 1:42 pm

    #1596687

  • RE: Grant persmissions to database

    sqlfriends (3/13/2013)

    ...They may need to read and write and also execute stored procedures in the databases...

    Typically when it comes to security you want to grant the least privileges that the...

    March 13, 2013 at 12:21 pm

    #1596655

  • RE: An Orders of Magnitude Problem (T-SQL Tuning)

    Jerry_Manioci (3/12/2013)...and simply added OPTION (FORCE ORDER) at the end of the query. It ran in record time in both test and production...

    Yep, the joy of cost based optimizers. ...

    March 13, 2013 at 10:50 am

    #1596626

Viewing 15 posts - 1,396 through 1,410 (of 1,838 total)