Welsh Corgi

Forum Replies Created

Viewing 15 posts - 871 through 885 (of 3,738 total)

RE: Opinion of use of LINQ

Lowell (4/3/2014)
Welsh to capture the code, for example, i decided the dmv's were not enough; not everything exists in the cache to check for performance issues.
Instead i started with a...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 4, 2014 at 5:46 pm

#1703456
RE: Opinion of use of LINQ

I do not like triggers either. Since it only fired when an abject was created, Dropped or modified it was not firing off that much. But now I know better.
I...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 4, 2014 at 7:04 am

#1703282
RE: Opinion of use of LINQ

Lowell (4/3/2014)
Welsh to capture the code, for example, i decided the dmv's were not enough; not everything exists in the cache to check for performance issues.
Instead i started with a...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 3, 2014 at 4:08 pm

#1703124
RE: Backups occuring twice at night, Native SQL Job backups scheduled for 8:00 PM

Jim_K (4/3/2014)
Hmm,
You wouldn't happen to be in a VM environment? I know there are some tools out there, such as Veeam, that will snapshot the database and record the fact...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 3, 2014 at 3:08 pm

#1703108
RE: Backups occuring twice at night, Native SQL Job backups scheduled for 8:00 PM

SQLRNNR (4/3/2014)
San snapshots can also cause an extra backup entry in your backuphistory. Are you doing SAN snapshots by chance?
I have to check with the Infrastructure Manager.
Thanks.:-)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 3, 2014 at 3:07 pm

#1703107
RE: Backups occuring twice at night, Native SQL Job backups scheduled for 8:00 PM

They are doing the COMMVault Backups.
They are also doing snapshot of the Server every hour.
I failed to mention that this is a Great Plains Server which was managed by someone...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 3, 2014 at 2:19 pm

#1703088
RE: Opinion of use of LINQ

Thanks for the good advice.
I should have done more research before asking the question.
Upon my request for information the developer gave me the connection string and it was the wrong...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 3, 2014 at 10:50 am

#1702968
RE: Opinion of use of LINQ

I regret the post.
I do everything to help my users.
I check the execution plans, add missing Indexes, rewrite the code, etc.
I would never do anything to hamper development or progress.
I...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 3, 2014 at 9:48 am

#1702932
RE: Opinion of use of LINQ

ok, I appreciate the feedback.
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

April 3, 2014 at 9:18 am

#1702912
RE: 3rd Party Backup Utility Hangs

homebrew01 (3/20/2014)
You could contact the backup software company. Perhaps they have "retry" settings that will help if there is contention or network problems.
I wish I could but I'm the DBA...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 20, 2014 at 8:34 am

#1698714
RE: 3rd Party Backup Utility Hangs

Thanks Jeff.
Fortunately the Backups did not hang last night.
I had this problem about a month ago on another server.
I was out on vacation but when I returned I discovered that...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 20, 2014 at 3:23 am

#1698602
RE: 3rd Party Backup Utility Hangs

Jeff Moden (3/19/2014)
Welsh Corgi (3/19/2014)
I have an Network Administrator running a 3rd Party Backup Utility on an instance of SQL Server.
On one instance the 3rd party Backups are hanging. Everything...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 19, 2014 at 5:18 pm

#1698550
RE: 3rd Party Backup Utility Hangs

sqlbuddy123 (3/19/2014)
Check for any resource contention issues on the server that's causing this. Usually this occurs due to poor I\O. Try to find on what are the backups waiting for...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 19, 2014 at 3:56 pm

#1698542
RE: Add Job Interval and Time to Script

I currently have this code which works. It shows all of the jobs that are running but have not completed:
SELECT DISTINCT 'CYP_BI' AS Server,Jobs.Name AS...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 19, 2014 at 9:18 am

#1698419
RE: Add Job Interval and Time to Script

HanShi (3/19/2014)
Adjust the WHERE clause to your own needs. I have chaged it (filter on name) to work in my own environment. It also filters to only display the jobs...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

March 19, 2014 at 7:24 am

#1698360

Viewing 15 posts - 871 through 885 (of 3,738 total)