Arsh

Forum Replies Created

Viewing 15 posts - 76 through 90 (of 340 total)

RE: After Insert trigger

Jeff Moden - Monday, June 25, 2018 6:24 AM
Arsh - Monday, June 25, 2018 1:27 AM

July 1, 2018 at 12:01 am

#1995931
RE: Grant Execute on an SP

Erland Sommarskog - Thursday, June 28, 2018 2:31 AM
Only granting access will not work, as User1 does not have access to DB2.
Certificate...

June 28, 2018 at 3:55 am

#1995581
RE: After Insert trigger

John Mitchell-245523 - Monday, June 25, 2018 2:07 AM
What do you get if you run this?
SELECT
entity_name
, subentity_name
, permission_name
FROM fn_my_permissions...

June 25, 2018 at 2:36 am

#1995099
RE: Calculating memory for SQL Server on a VM machine

While there's no specific algorithm to get a magic number, what one has to do is to first get an ideal about much memory the applications need . To...

April 7, 2018 at 1:47 am

#1985876
RE: Very erratic performance in last few days.

Did you look at ASYNC_NETWORK_IO wait type trend at time . Check this in conjunction with inputs from network team .

February 19, 2018 at 11:36 am

#1980309
RE: Regarding Mirroring setup - TCP/IP network issue

Arsh - Monday, February 19, 2018 11:11 AM
Taking further, you need to have a service account for running both the SQL servers.
Mirroring...

February 19, 2018 at 11:24 am

#1980307
RE: SQL server 2008 R2 frequent transaction log full and my database is a mirrored one.

anjang2k - Thursday, November 30, 2017 11:08 PM
At present we normally do the above mentioned steps once in 5 days.We backup...

February 19, 2018 at 11:21 am

#1980306
RE: Regarding Mirroring setup - TCP/IP network issue

SQLisAwE5OmE - Friday, January 12, 2018 2:37 PM
Hi Team,
I tried setting up DB mirroring between PRD & DR side and I am...

February 19, 2018 at 11:11 am

#1980302
RE: INSERT running slow in SQL 2016

coolchaitu - Wednesday, January 24, 2018 11:24 PM
Good Morning Experts,
We had a database on SQL Server 2012. INSERTS were running fine....

February 14, 2018 at 11:28 am

#1979790
RE: index was outside the bounds of the array

The version your using to connect has to be equal or higher than the one your connecting to. So it should be minimum 2014 or higher in ur case...

February 14, 2018 at 10:24 am

#1979776
RE: Can't get rid of databases

Why do you want to uninstall the SQL server instance when you only want to get rid of the databases (better to share what u r trying to fix) ? ...

February 14, 2018 at 7:13 am

#1979729
RE: Huge table.and poor performance.

Looking at the code would give a much better idea about what's happening . Hence please share the query here. Most of the times the real culprit turns out to...

February 14, 2018 at 7:09 am

#1979727
RE: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. provider: SSL Provider, error: 0

If this happens without any change applied the system , I suggest you check with the infrastructure for any network latency at that time.

February 14, 2018 at 7:01 am

#1979723
RE: Index Fill Factor

I acknowledge what you are saying and agree. . My mention of scenarios represents bigger picture.I would try to write a post as I get docs for backing up .The...

February 6, 2018 at 9:28 pm

#1978810
RE: Index Fill Factor

Thanks George for sharing the docs.

February 6, 2018 at 9:20 pm

#1978809

Viewing 15 posts - 76 through 90 (of 340 total)