Standard Members Archives - Page 71 of 110

Standard Members

Tips for using SQL Server 2014 cursors

by Alexander Chigrik

Tips for using SQL Server 2014 cursors Try to avoid using insensitive, static and keyset cursors, whenever possible. These types of cursor produce the largest amount of overhead on SQL Server 2014, because they cause a temporary table to be created in TEMPDB, which results in some performance degradation. Use FAST_FORWARD cursors, whenever possible. The FAST_FORWARD cursors produce the least...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Microsoft SQL Server 2014: Database Engine key new features – (Part 3)

by Basit Aalishan Masood-Al-Farooq

Microsoft SQL Server 2014: Database Engine key new features – (Part 3) Author: Basit A. Farooq This is the third part of my article series on Microsoft SQL Server 2014: Database Engine key new feature. In this part, I will talk about following two SQL Server 2014 features: Encryption for Backups and Resource Governor Enhancements for Physical I/O control. Encryption...

Already a member? Log in here

Continue Reading →

Development Pro Members Standard Members

How do you handle friend-ing requests from your boss

by Laura Lee Rose

How To Handle Friend Requests From Your Boss Hello, this is Laura Lee Rose. I am a speaker and author. I am an expert in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if they don’t have...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Tips for using SQL Server 2014 triggers

by Alexander Chigrik

Tips for using SQL Server 2014 triggers Try to minimize the DML trigger’s code size. Triggers fire during INSERT, UPDATE, or DELETE statements, so the more code that runs in the trigger, the slower each INSERT, UPDATE, and DELETE that fires it will be. Use cascading referential integrity constraints instead of triggers whenever possible. For example, if you need to...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Microsoft SQL Server 2014: Database Engine key new features – (Part 2)

by Basit Aalishan Masood-Al-Farooq

Microsoft SQL Server 2014: Database Engine key new features – (Part 2) Author: Basit A. Farooq This is the second part of my article series on Microsoft SQL Server 2014: Database Engine key new feature. In this part, I will talk about SQL Server 2014 columnstore indexes. Updateable clustered columnstore index With the release of SQL Server 2012, Microsoft introduced...

Already a member? Log in here

Continue Reading →

Development Pro Members Standard Members

How to get a good reference

by Laura Lee Rose

How to Get a Good Reference Hello, this is Laura Lee Rose. I am a speaker and author. I am an expert in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if they don’t have time to...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Undocumented SQL Server 2012 Full-Text Search Stored Procedures

by Alexander Chigrik

Undocumented SQL Server 2012 Full-Text Search Stored Procedures SQL Server 2012 supports the following three undocumented full-text search system stored procedures: sp_fulltext_recycle_crawl_log sp_MShelpfulltextindex sp_MShelpfulltextscript sp_fulltext_recycle_crawl_log The sp_fulltext_recycle_crawl_log system stored procedure is used to recycle crawl log for the given full-text catalog name. Syntax sp_fulltext_recycle_crawl_log [ @ftcat = ] ‘ftcat’ Arguments [ @ftcat = ] ‘ftcat’ Is the full-text catalog name...

Already a member? Log in here

Continue Reading →

Development Pro Members Standard Members

How to handle obnoxious questions about your job search.

by Laura Lee Rose

How to Handle Obnoxious Questions About Your Job Search Hello, this is Laura Lee Rose. I am a speaker and author. My background is in time and project management. I help busy professionals and entrepreneurs create effective systems so that they can comfortably delegate to others, be more profitable and have time to enjoy life even if they don’t have...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

Undocumented SQL Server 2012 Database Mail Procedures

by Alexander Chigrik

Undocumented SQL Server 2012 Database Mail Procedures SQL Server 2012 supports the following useful undocumented database mail stored procedures: sp_RunMailQuery sp_SendMailMessage sp_sysmail_activate sysmail_verify_account_sp sysmail_verify_principal_sp sysmail_verify_profile_sp sp_RunMailQuery The sp_RunMailQuery database mail stored procedure is used to run the mail query. This stored procedure is used in the sp_send_dbmail stored procedure to execute a query if query is specified. Syntax sp_RunMailQuery [...

Already a member? Log in here

Continue Reading →

Pro Members SQL Server Standard Members

SQL Server 2014 Replication – Part 1

by Basit Aalishan Masood-Al-Farooq

SQL Server 2014 Replication – Part 1 Author: Basit A. Farooq; You use replication to move data between servers. Replication is important in distributed environments, when archiving data, and as an inexpensive way to support high availability. In this topic, you will learn about the different types of replication, the components involved in replication, and the steps necessary to configure...

Already a member? Log in here

Continue Reading →