Forum Replies Created

Viewing 15 posts - 1 through 15 (of 285 total)

  • Reply To: 'Too many parameters..' error

    Oh , I figured it out. I was actually calling some other procedure with almost similar name, Caught it...thanks though.

  • Reply To: question about Always on

    You can try something called ‘Double Take that synchronises the selected data at bit level . hope that helps.

     

  • RE: Buffer Cache Hit Ratio - PLE

    Grant Fritchey - Thursday, September 20, 2018 5:07 AM

    Those should return data. If they're not, it's likely that something is up with...

  • RE: Buffer Cache Hit Ratio - PLE

    Grant Fritchey - Wednesday, September 19, 2018 5:51 AM

    Again, how are you recording them?

    I am querying them first time. I used the queries...
  • RE: Buffer Cache Hit Ratio - PLE

    Grant Fritchey - Wednesday, September 19, 2018 4:37 AM

    How are you measuring the Buffer Cache Hit Ratio on a per database basis?...

  • RE: Slow running query - only off peak

    Did you check for any disk stalls ? I mean io_pendings on the disk .

    Best Regards..Arshad

  • RE: Unused Indexes

    Jeff Moden - Sunday, September 16, 2018 9:54 AM

    The trouble is that view resets to being empty when the SQL Server...

  • RE: Unused Indexes

    Thank you Sue . Thank you to you too SQLPirate ; and Yes I am usage dm_db_usage_stats . Your query gets everything and that's useful as well.

    Best...

  • RE: Last Security Patch

    Sue_H - Wednesday, September 12, 2018 6:50 AM

    Yes, you are correct. And the description does list if it's a security update,...

  • RE: Last Security Patch

    Thanks Sue . So in the list , whatever appears above the patch level we are at , is what remains as unapplied so far . Is my thinking...
  • RE: Indexing a character column

    Hi Grant,
    Thanks for pointing out my typo. Yes, I meant the data type of those columns in question being Non-Numeric. Was a bit concerned about the search mechanism...
  • RE: Cursor object running when @@FETCHSTATUS 0

    Dear All,
    I've simplified the code for the test case , and now it looks like below . Though there are no records , the control goes in While...
  • RE: Cursor object running when @@FETCHSTATUS 0

    Dear All,
    I've attached the SP in this file  for reference in case the code is not readable in the 'Post' window here. Quick advise / input on...
  • RE: Left padding a FLOAT type with zeroes

    andycadley - Sunday, July 29, 2018 4:26 AM

    If you know the values will always be whole numbers, you could cast it to...

  • RE: SA user unable to access a database

    Jeffrey Williams 3188 - Thursday, July 26, 2018 11:58 AM

    EXECUTE AS login = 'user login';
    GO

    EXECUTE {database}.{schema}.procedure
    GO

    REVERT;
    GO

    Hi Jeffrey,
    Got it working by removing...

Viewing 15 posts - 1 through 15 (of 285 total)