Feivel

Forum Replies Created

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

RE: Refreshing lower environments with prod copy

Jeff Moden - Monday, April 23, 2018 9:34 AM
Get your infrastructure folks to automate SAN snapshots for you. They're nearly instantaneous.
Thanks! Jeff....

April 23, 2018 at 11:02 am

#1987917
RE: Refreshing lower environments with prod copy

Grant Fritchey - Monday, April 23, 2018 6:49 AM
Without using log shipping or replication or availability groups (all of which you've dismissed),...

April 23, 2018 at 9:24 am

#1987906
RE: Backup and restore speeds are significantly slower on flash storage than on sas drives.

Jeff Moden - Friday, April 20, 2018 7:25 AM
Feivel - Thursday, April 19, 2018 2:07 PM

April 20, 2018 at 2:41 pm

#1987768
RE: Backup and restore speeds are significantly slower on flash storage than on sas drives.

sgmunson - Friday, April 20, 2018 6:45 AM
Feivel - Thursday, April 19, 2018 2:07 PM

April 20, 2018 at 2:27 pm

#1987765
RE: Backup and restore speeds are significantly slower on flash storage than on sas drives.

taseedorf - Thursday, April 19, 2018 3:45 PM
Are they backing up to the same place?
Have you done write tests outside of SQL...

April 19, 2018 at 9:00 pm

#1987621
RE: Db name inside the stored proc

sgmunson - Tuesday, April 3, 2018 10:43 AM
If you decide to stick with the current methodology, here's the how:--USE [AdvWorks]
GO
SET ANSI_NULLS ON;
GO
SET...

April 3, 2018 at 11:29 am

#1985337
RE: Updating base tables through views in 2 separate DBs through DB Chaining.

Alexander Zhang - Thursday, March 8, 2018 11:00 AM
ffarouqi - Wednesday, March 7, 2018 11:30 AM

March 8, 2018 at 11:23 am

#1982528
RE: SQL job run skipped...need to find out why?

SQLPirate - Thursday, February 22, 2018 2:29 PM
ffarouqi - Thursday, February 22, 2018 2:10 PM

February 22, 2018 at 2:41 pm

#1980865
RE: SQL job run skipped...need to find out why?

SQLPirate - Thursday, February 22, 2018 1:53 PM
So the job ran every time up until 2/21? And you confirmed that the job...

February 22, 2018 at 2:10 pm

#1980859
RE: How would you lock down a SQL DBA to have local admin on the SQL box

Steve Jones - SSC Editor - Thursday, February 22, 2018 9:51 AM
For Perf counters, there are ways to let non-admins get them:...

February 22, 2018 at 10:59 am

#1980805
RE: Please delete this post

Eirikur Eiriksson - Wednesday, February 14, 2018 12:18 AM
ffarouqi - Tuesday, February 13, 2018 1:59 PM

February 14, 2018 at 12:29 am

#1979684
RE: Please delete this post

GilaMonster - Tuesday, February 13, 2018 3:30 PM
It loops over one table and inserts the values, one by one, into another table....

February 13, 2018 at 3:37 pm

#1979665
RE: Please delete this post

GilaMonster - Tuesday, February 13, 2018 2:25 PM
You could start by getting rid of the unnecessary cursor.
Thank you for your response but...

February 13, 2018 at 3:26 pm

#1979662
RE: Moving distribution database from one server to another with minimal downtime and without breaking replication

Sue_H - Thursday, February 8, 2018 2:15 PM
ffarouqi - Thursday, February 8, 2018 12:38 PM

February 8, 2018 at 4:54 pm

#1979137
RE: how to find if xp_cmdshell is being used or not

Jeff Moden - Monday, January 29, 2018 2:30 PM
ffarouqi - Monday, January 29, 2018 2:18 PM

January 29, 2018 at 2:44 pm

#1977781

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