Alexander Zhang

Forum Replies Created

Viewing 15 posts - 16 through 30 (of 75 total)

RE: SSD server with 1 logical drive

Jeff Moden - Tuesday, February 13, 2018 9:43 PM
Alexander Zhang - Tuesday, February 13, 2018 3:07 PM
GASQL.com - Focus on Database and Cloud

March 6, 2018 at 10:18 am

#1982107
RE: Verify backup files. How much does it help?

Summer90 - Monday, March 5, 2018 1:37 PM
Alexander Zhang - Friday, March 2, 2018 9:15 AM
GASQL.com - Focus on Database and Cloud

March 6, 2018 at 10:05 am

#1982104
RE: Multiple instances in one server

PiManÃ© - Saturday, March 3, 2018 10:50 AM
The databases vary from 150MB to 1GB, but most are 150MB, the average is 300MB.
There...
GASQL.com - Focus on Database and Cloud

March 3, 2018 at 4:36 pm

#1981862
RE: Verify backup files. How much does it help?

Thanks guys for your input. I will give up implementing backup and Verify in parallel. Instead, I will...
GASQL.com - Focus on Database and Cloud

March 2, 2018 at 9:15 am

#1981778
RE: Verify backup files. How much does it help?

RVSC48 - Wednesday, February 28, 2018 2:44 PM
Experts say, rather than do a verify, simply prove the backup is a good one...
GASQL.com - Focus on Database and Cloud

February 28, 2018 at 8:26 pm

#1981574
RE: mscorlib version=2.0.5.0 issue when trying to CREATE ASSEMBLY in SQL Server 2012

bhee - Friday, March 13, 2015 8:28 AM
Trying to CREATE ASSEMBLY in MS SQL Server 2012 SP1.Assembly was developed in Visual Studio...
GASQL.com - Focus on Database and Cloud

February 28, 2018 at 10:29 am

#1981503
RE: Can an availability group secondary db be a replication publisher

Radders - Tuesday, February 27, 2018 8:59 AM
Hi All,
I have a 3 node AOAG setup:
Primary Site: Node1 and Node2
DR Site: Node3
I want...
GASQL.com - Focus on Database and Cloud

February 28, 2018 at 10:22 am

#1981501
RE: Microsoft ODBC Drivers

DBA_Learner - Wednesday, February 28, 2018 9:00 AM
Hello Admins,
I see Microsoft releases ODBC drivers very often. Is it part of DBA responsibility...
GASQL.com - Focus on Database and Cloud

February 28, 2018 at 10:12 am

#1981497
RE: File 'xxxx' is not a recognizable trace file

RandomStream - Tuesday, February 27, 2018 6:04 PM
Have you tried stopping and removing the trace? If it works after the trace has...
GASQL.com - Focus on Database and Cloud

February 28, 2018 at 9:58 am

#1981493
RE: What are SHOWPLAN security risks? Should a query optimizer person (not DBA) have access to it?

peter_parker - Monday, February 26, 2018 2:01 PM
Thanks for the replies both. They are both pretty useful and generally my thought process.
It...
GASQL.com - Focus on Database and Cloud

February 27, 2018 at 3:28 pm

#1981381
RE: upsert in ssis for large tables

MMartin1 - Monday, February 26, 2018 4:54 PM
Alexander Zhang - Monday, February 26, 2018 2:11 PM
GASQL.com - Focus on Database and Cloud

February 27, 2018 at 3:06 pm

#1981376
RE: upsert in ssis for large tables

It looks like full copy from prod to lower environments on daily basis. If so, why not backup and restore? Or something like SQL Clone?
GASQL.com - Focus on Database and Cloud

February 26, 2018 at 2:11 pm

#1981192
RE: DTSX Pkg From Stored Procedure (completely frustrated)

1. Must enable 'show advanced options'
2. Make sure 'Microsoft.ACE.OLEDB.12.0' is ready in Provider of link server. Otherwise, download and install it. Note, I guess you need x64 version - AccessDatabaseEngine_X64.exe
GASQL.com - Focus on Database and Cloud

February 26, 2018 at 2:01 pm

#1981188
RE: File 'xxxx' is not a recognizable trace file

GilaMonster - Monday, February 26, 2018 10:02 AM
The file is the one currently being written to. When you copy it, that's no...
GASQL.com - Focus on Database and Cloud

February 26, 2018 at 10:31 am

#1981146
RE: SQL Security

orcking - Saturday, February 24, 2018 9:17 AM
Hi I have SQL Express 2014
Is it possible to limit process access to a signed ...
GASQL.com - Focus on Database and Cloud

February 26, 2018 at 10:21 am

#1981143

Viewing 15 posts - 16 through 30 (of 75 total)