Arsh

Forum Replies Created

Viewing 15 posts - 61 through 75 (of 340 total)

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...

September 17, 2018 at 1:53 am

#2005919
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...

September 16, 2018 at 4:31 am

#2005884
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,...

September 16, 2018 at 2:20 am

#2005883
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...

September 12, 2018 at 4:38 am

#2005378
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...

September 4, 2018 at 6:40 am

#2004337
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...

August 5, 2018 at 3:40 am

#2000299
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...

August 5, 2018 at 3:16 am

#2000297
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...

July 29, 2018 at 7:45 am

#1999388
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...

July 29, 2018 at 1:35 am

#1999383
RE: SA user unable to access a database

Jeffrey Williams 3188 - Wednesday, July 25, 2018 12:44 PM
You don't need to deny privileges to the user in D2 - which...

July 25, 2018 at 11:25 pm

#1999033
RE: Fetching cols from multiple tables in a cursor query

alastair.beveridge - Monday, July 23, 2018 4:18 AM
why would you want to do this in a cursor?
but if you really do, you...

July 23, 2018 at 7:04 am

#1998582
RE: Comparing E mail address through SP

Hi Thom A and Thom R,
The objects provided you works well. I simulated this in our scenario of invoking the SP from another DB after grant execute and...

July 3, 2018 at 4:38 am

#1996110
RE: After Insert trigger

Arsh - Sunday, July 1, 2018 12:01 AM
Jeff Moden - Monday, June 25, 2018 6:24 AM

July 3, 2018 at 2:19 am

#1996097
RE: Grant Execute on an SP

Arsh - Sunday, July 1, 2018 12:43 AM
Erland Sommarskog - Thursday, June 28, 2018 5:40 AM

July 1, 2018 at 1:51 am

#1995936
RE: Grant Execute on an SP

Erland Sommarskog - Thursday, June 28, 2018 5:40 AM
Yet a caveat with cross-DB chaining is that persons who have permissions to create...

July 1, 2018 at 12:43 am

#1995932

Viewing 15 posts - 61 through 75 (of 340 total)