Performance Tuning Using Extended Events: Part 2 (SQLServerCentral 4/27/2017)

[SQLServerCentral - www.sqlservercentral.com]( A community of more than 1,600,000 database professionals and growing Featured Contents - [Performance Tuning Using Extended Events: Part 2]( - [SQL Clone Trivia Quiz - win a $10 gift card every weekday in April]( - [Doing Fuzzy Searches in SQL Server]( - [Free webinar: dealing with SQL Server asset management]( - [Thoughts about the Microsoft Data Amp Announcements]( (From the SQLServerCentral Blogs) - [The Dead Tree Database]( (From the SQLServerCentral Blogs) Featured Script - [DigitsOnlyEE and AlphaNumericOnly]( The Voice of the DBA SQL Server on Linux is Just SQL Server I've been working with the SQL Server on Linux (SSoL) version for quite some time, almost a year. In all of that time, I've for the most part found that SQL Server is SQL Server. When I connect, run demos, check code, almost everything just works. If I didn't bother to check @@version, this would appear to be just another SQL Server to me. That's what [a new video on Channel 9]( shows as well. SQL Server is pretty much the same on both platforms. I've tested the Redgate tools and to all of them, SSoL is just SQL Server. There are some differences, which is to be expected. Any operations that access the file system and require paths work a bit differently, and for those people that end up administering the product, there will be some changes to get used to. The advanced HA features are similar, but again, some work is required. However, this isn't all bad. I'm impressed with the apt-get process (I'm testing on Ubuntu), which is way, way easier than any patching or updating process I've gone through on Windows. In fact, setting up an Ubuntu VM last year was easy, and installing SQL Server was about as easy as it could be. The tooling on Linux isn't as mature, and I don't know when we will see a GUI client, but as I move more and more to PoSh or scripting to make changes in SQL Server, I expect more and more people to manage both Windows and Linux versions in the same way. Certainly using SSMS to write queries is a much nicer experience, and I would guess that many developers that might run SQL Server on OSX or Linux will want a Windows VM for SSMS. Of course, since [Visual Studio is now on OSX](, maybe we'll see SSMS running natively on other platforms. I don't know how many enterprises will run SQL Server on Linux, but I'm sure there are some that will. I don't think a lot of organizations will move from Windows to Linux, unless they have loved SQL Server enough to install a single Windows host for the database and want to get rid of it now. I do think lots of developers will run SQL Server on Linux/OSX, especially in containers, where it is really easy to get a container running on their platforms. If you've experimented with SQL Server on Linux, or you are excited, let us know. If you think your organization might use this platform, let us know as well. I suspect a few of you will just because you can, which is as good a reason as any. Steve Jones from [SQLServerCentral.com]( Join the debate, and [respond to today's editorial on the forums]( ADVERTISEMENT [SQL Toolbelt]( Not enough hours in your day? The SQL Toolbelt lets you reduce the time spent on SQL Server development and administration. Cambridge University developer David Spaxman, for example, says: “I’m saving 10-12 hours a week using the SQL Toolbelt.” Learn how you can double your productivity, speed up deployments and protect your data. [Download a free trial.]( [SQL Clone]( NEW SQL Clone - version 1 available now! Create copies of production databases and SQL backups in seconds and save up to 99% of disk space using SQL Clone. Redgate’s new tool removes much of the time and resource needed to create and manage database copies, allowing teams to work on local environments to develop, test and diagnose issues faster. [Try it free.]( Featured Contents  [] [Performance Tuning Using Extended Events: Part 2]( Brian Davey from [SQLServerCentral.com]() Part 2 of identifying performance puning opportunities using Extended Events. Learn how about shredding XML.[More »](Events/154824/) ---------------------------------------------------------------  [] [SQL Clone Trivia Quiz - win a $10 gift card every weekday in April]( To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage.[More »]( ---------------------------------------------------------------  [] [Doing Fuzzy Searches in SQL Server]( Additional Articles from [SimpleTalk]() A series of arguments with developers who insist that fuzzy searches or spell-checking be done within the application rather then a relational database inspired Phil Factor to show how it is done. When the database must find relevant material from search terms entered by users, the database must learn to expect, and deal with, both expected and unexpected.[More »]( ---------------------------------------------------------------  [] [Free webinar: dealing with SQL Server asset management]( In this interactive webinar, Microsoft Data Platform MVP Steve Jones and members of Redgate’s R&D division, Foundry, will lead a group discussion with attendees to take an in-depth look at the challenges of managing a SQL Server estate. They’ll cover the strategies for discovering the full extent of your estate, and look at how to mitigate security risks, ensure consistent server configurations, and respond to and prevent incidents. We’ll also share some horror stories on the way. [More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Thoughts about the Microsoft Data Amp Announcements]( DataOnWheels from [SQLServerCentral Blogs]( Microsoft conducted a live event called Microsoft Data Amp to announce a number of key features and releases for SQL...[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [The Dead Tree Database]( Tim Mitchell from [SQLServerCentral Blogs]( “We have all of that information. It’s in a database in my office.” This phrase was music to my ears....[More »]( Question of the Day Today's Question (by Steve Jones): I am creating a Database Encryption Key for use in TDE. What are the options for an algorithm in SQL Server 2016? Think you know the answer? [Click here](, and find out if you are right. --------------------------------------------------------------- We keep track of your score to give you bragging rights against your peers. This question is worth 1 point in this category: Transparent Data Encryption (TDE). We'd love to give you credit for your own question and answer. To submit a QOTD, simply log in to the [Contribution Center](. ADVERTISEMENT [Exam Ref 70-762 Developing SQL Databases]( Prepare for Microsoft Exam 70-762, Developing SQL Databases –and help demonstrate your real-world mastery of skills for building and implementing databases across organizations. Designed for database professionals who build and implement databases across organizations and who ensure high levels of data availability, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. [Get your copy from Amazon today](. Yesterday's Question of the Day Yesterday's Question (by Steve Jones): I see this code in an R script: 42 -> x What does this do? Answer: This assigns the value of 42 to x Explanation: This is also an assignment operator. 42 is now the value in x. Ref: R assignment operators - [click here]( --------------------------------------------------------------- [» Discuss this question and answer on the forums]( Featured Script [DigitsOnlyEE and AlphaNumericOnly]( Alan Burstein from [SQLServerCentral.com]() Intro In June, 2014 someone asked if anyone had a [StripNonNumeric ITVF function](. This request would lead to a few RBAR-free, set-based functions designed to clean strings. For the next few months members of the SQL Server community put their heads together and, after a bunch of testing came up with DigitsOnlyEE, the fastest T-SQL function for removing non-numeric characters from a string available today. Designing DigitsOnlyEE as an inline table valued function makes it possible to speed it up even more by forcing a parallel execution plan with Adam Machanic's [make_parallel](. A couple tweaks later we also had an AlphaNumericOnly ITVF. In April, 2017 I added AlphaOnly which removes all non-alphabetical characters. What about PatExclude8K or PatReplace8K? [PatExclude8K]( and [PatReplace8K]( came out of the aforementioned effort and could be used for removing non-numeric or non-alphanumeric characters as shown below. --===== PatExclude8K: SELECT NewString FROM dbo.PatExclude8K('???ABC-123!!!','[^0-9]'); -- remove non-numeric characters SELECT NewString FROM dbo.PatExclude8K('???ABC-123!!!','[^0-9A-Za-z]'); -- remove non-alphanumeric --===== PatReplace8K: SELECT NewString FROM dbo.PatReplace8K('???ABC-123!!!','[^0-9]',''); -- remove non-numeric characters SELECT NewString FROM dbo.PatReplace8K('???ABC-123!!!','[^0-9A-Za-z]',''); -- remove non-alphanumeric DigitsOnlyEE and AlphaNumericOnly are much faster and better suited for this task, let me explain why: PatExclude8K and PatReplace8K both use a tally table to split the string into unigrams, then use the FOR XML PATH('') trick to put the string back together excluding characters that match the exclusion pattern (@pattern). Here's the code from PatExlclude8K: ... SELECT NewString = ( SELECT SUBSTRING(@String,N,1) FROM iTally WHERE 0 = PATINDEX(@Pattern,SUBSTRING(@String COLLATE Latin1_General_BIN,N,1)) FOR XML PATH('') ,TYPE ) .value('.[1]','varchar(8000)') ; Note the TYPE and .value('.[1]', 'varchar(8000)') code. Removing this code would make the function notably faster. Unfortunately, PatExclude8K and PatReplace8K require this code in case the preserved text includes special XML characters. Wayne Sheffield discusses this topic in his article: [Creating a comma-separated list (SQL Spackle)](: The TYPE clause specifies to return the data as an XML type. The .value('.','varchar(max)') takes each value, and converts it into a varchar(max) data type. The combination of the TYPE and .value means that values are created at XML tags (such as the ampersand (&), and the greater than (>) and less than (<) signs), will not be tokenized into their XML representations and will remain as is. We don't need to include the TYPE and .value('.[1]', 'varchar(8000)') code for DigitsOnlyEE or AlphaNumericOnly because the preserved characters are numbers and letters only. There are other performance enhancements which are documented in the comment section of each function. Happy string manipulating! DigitsOnlyEE IF OBJECT_ID('dbo.DigitsOnlyEE') IS NOT NULL DROP FUNCTION dbo.DigitsOnlyEE; GO CREATE FUNCTION dbo.DigitsOnlyEE (@pString VARCHAR(8000)) /**************************************************************************************** Purpose: Given a VARCHAR(8000) or less string, return only the numeric digits from the string. Compatibility: SQL Server 2008+, Azure SQL Database, Azure SQL Data Warehouse & Parallel Data Warehouse Parameters: @pString = varchar(8000); Input string to be cleaned Returns: DigitsOnly = nvarchar(max) Syntax: --===== Autonomous SELECT ca.DigitsOnly FROM dbo.DigitsOnly(@pString) ca; --===== CROSS APPLY example SELECT ca.DigitsOnly FROM dbo.SomeTable CROSS APPLY dbo.DigitsOnly(SomeVarcharCol) ca Programmer's Notes: 1. This is an iTVF (Inline Table Valued Function) that performs the same task as a scalar user defined function (UDF) accept that it requires the APPLY table operator. Note the usage examples below and See this article for more details: The function will be slightly more complicated to use than a scalar UDF but will yeild much better performance. For example - unlike a scalar UDF, this function does not restrict the query optimizer's ability generate a parallel query plan. Initial testing showed that the function generally gets a 2. Runs 2-4 times faster with a parallel query plan. For optimal performance use Adam Machanic's make_parallel() function (provided that you are on a machine with two or more logical CPUs). make_parallel can be found here: sqlblog.com/blogs/adam_machanic/archive/2013/07/11/next-level-parallel-plan-porcing.aspx 3. This is an iTVF (Inline Table Valued Function) that will be used as an iSF (Inline Scalar Function) in that it returns a single value in the returned table and should normally be used in the FROM clause as with any other iTVF. 4. CHECKSUM returns an INT and will return the exact number given if given an INT to begin with. It's also faster than a CAST or CONVERT and is used as a performance enhancer by changing the BIGINT of ROW_NUMBER() to a more appropriately sized INT. 5. Another performance enhancement is using a WHERE clause calculation to prevent the relatively expensive XML PATH concatentation of empty strings normally determined by a CASE statement in the XML "loop". 6. Another performance enhancement is not making this function a generic function that could handle a pattern. That allows us to use all integer math to do the comparison using the high speed ASCII function convert characters to their numeric equivalent. ASCII characters 48 through 57 are the digit characters of 0 through 9. 7. Keep in mind that DigitsOnlyEE returns an nvarchar(max) value. If you are returning small numbers consider casting or converting yout values to a numeric data type if you are inserting the return value into a new table or using it for joins or comparison purposes. 8. DigitsOnlyEE is deterministic; for more about deterministic and nondeterministic functions see Kudos: 1. Hats off to Eirikur Eiriksson for the ASCII conversion idea and for the reminders that dedicated functions will always be faster than generic functions and that integer math beats the tar out of character comparisons that use LIKE or PATINDEX. 2. Hats off to all of the good people that submitted and tested their code on the following thread. It's this type of participation and interest that makes code better. You've just gotta love this commmunity. Usage Examples: --===== 1. Basic use against a literal SELECT DigitsOnly FROM dbo.DigitsOnlyEE('xxx123abc999!!!'); --===== 2. Against a table DECLARE @sampleTxt TABLE (txtID int identity, txt varchar(100)); INSERT @sampleTxt(txt) VALUES ('abc123'),('!!!555!!!'),('000.999'),(NULL); SELECT txtID, OldTxt = txt, DigitsOnly FROM @sampleTxt st CROSS APPLY dbo.DigitsOnlyEE(st.txt); --------------------------------------------------------------------------------------- Revision History: Rev 00 - 20141029 - Initial Creation - Jeff Moden Rev 01 - 20141210 - TOP clause changed to handle NULL inputs - Eirikur Eiriksson Rev 02 - 20160512 - Substantial updates to the comments & examples - Alan Burstein ****************************************************************************************/ RETURNS TABLE WITH SCHEMABINDING AS RETURN WITH E1(N) AS ( SELECT N FROM (VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL))X(N) ), iTally(N) AS ( SELECT TOP (LEN(ISNULL(@pString,CHAR(32)))) (CHECKSUM(ROW_NUMBER() OVER (ORDER BY (SELECT NULL)))) FROM E1 a CROSS JOIN E1 b CROSS JOIN E1 c CROSS JOIN E1 d ) SELECT DigitsOnly = ( SELECT SUBSTRING(@pString,N,1) FROM iTally WHERE ((ASCII(SUBSTRING(@pString,N,1)) - 48) & 0x7FFF) < 10 FOR XML PATH('') ); AlphaNumericOnly IF OBJECT_ID('dbo.AlphaNumericOnly') IS NOT NULL DROP FUNCTION dbo.AlphaNumericOnly; GO CREATE FUNCTION dbo.AlphaNumericOnly (@pString varchar(8000)) RETURNS TABLE WITH SCHEMABINDING AS RETURN /**************************************************************************************** Purpose: Given a VARCHAR(8000) or less string, returns only the alphanumeric digits from the string. Compatibility: SQL Server 2008+, Azure SQL Database, Azure SQL Data Warehouse & Parallel Data Warehouse Parameters: @pString = varchar(8000); Input string to be cleaned Returns: AlphaNumericOnly - nvarchar(max) Syntax: --===== Autonomous SELECT ca.AlphaNumericOnly FROM dbo.AlphaNumericOnly(@pString) ca; --===== CROSS APPLY example SELECT ca.AlphaNumericOnly FROM dbo.SomeTable st CROSS APPLY dbo.AlphaNumericOnly(st.SomeVarcharCol) ca; Programmer's Notes: 1. Based on Jeff Moden/Eirikur Eiriksson's DigitsOnlyEE function. For more details see: 2. This is an iTVF (Inline Table Valued Function) that performs the same task as a scalar user defined function (UDF) accept that it requires the APPLY table operator. Note the usage examples below and see this article for more details: The function will be slightly more complicated to use than a scalar UDF but will yeild much better performance. For example - unlike a scalar UDF, this function does not restrict the query optimizer's ability generate a parallel query plan. Initial testing showed that the function generally gets a 3. AlphaNumericOnly runs 2-4 times faster when using make_parallel() (provided that you have two or more logical CPU's and MAXDOP is not set to 1 on your SQL Instance). 4. This is an iTVF (Inline Table Valued Function) that will be used as an iSF (Inline Scalar Function) in that it returns a single value in the returned table and should normally be used in the FROM clause as with any other iTVF. 5. CHECKSUM returns an INT and will return the exact number given if given an INT to begin with. It's also faster than a CAST or CONVERT and is used as a performance enhancer by changing the BIGINT of ROW_NUMBER() to a more appropriately sized INT. 6. Another performance enhancement is using a WHERE clause calculation to prevent the relatively expensive XML PATH concatentation of empty strings normally determined by a CASE statement in the XML "loop". 7. Note that AlphaNumericOnly returns an nvarchar(max) value. If you are returning small numbers consider casting or converting yout values to a numeric data type if you are inserting the return value into a new table or using it for joins or comparison purposes. 8. AlphaNumericOnly is deterministic; for more about deterministic and nondeterministic functions see Usage Examples: --===== 1. Basic use against a literal SELECT ao.AlphaNumericOnly FROM dbo.AlphaNumericOnly('xxx123abc999!!!') ao; --===== 2. Against a table DECLARE @sampleTxt TABLE (txtID int identity, txt varchar(100)); INSERT @sampleTxt(txt) VALUES ('!!!A555A!!!'),(NULL),('AAA.999'); SELECT txtID, OldTxt = txt, AlphaNumericOnly FROM @sampleTxt st CROSS APPLY dbo.AlphaNumericOnly(st.txt); --------------------------------------------------------------------------------------- Revision History: Rev 00 - 20150526 - Inital Creation - Alan Burstein Rev 00 - 20150526 - 3rd line in WHERE clause to correct something that was missed - Eirikur Eiriksson ****************************************************************************************/ WITH E1(N) AS ( SELECT N FROM (VALUES (NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL),(NULL))X(N) ), iTally(N) AS ( SELECT TOP (LEN(ISNULL(@pString,CHAR(32)))) (CHECKSUM(ROW_NUMBER() OVER (ORDER BY (SELECT NULL)))) FROM E1 a CROSS JOIN E1 b CROSS JOIN E1 c CROSS JOIN E1 d ) SELECT AlphaNumericOnly = ( SELECT SUBSTRING(@pString,N,1) FROM iTally WHERE ((ASCII(SUBSTRING(@pString,N,1)) - 48) & 0x7FFF) < 10 OR ((ASCII(SUBSTRING(@pString,N,1)) - 65) & 0x7FFF) < 26 OR ((ASCII(SUBSTRING(@pString,N,1)) - 97) & 0x7FFF) < 26 FOR XML PATH('') ); AlphaOnly IF OBJECT_ID('dbo.AlphaOnly') IS NOT NULL DROP FUNCTION dbo.AlphaOnly; GO CREATE FUNCTION dbo.AlphaOnly (@pString varchar(8000)) RETURNS TABLE WITH SCHEMABINDING AS RETURN /**************************************************************************************** Purpose: Given a VARCHAR(8000) or less string, returns only the alphabetical digits from the input string (@pString). Compatibility: SQL Server 2008+, Azure SQL Database, Azure SQL Data Warehouse & Parallel Data Warehouse Parameters: @pString = varchar(8000); Input string to be cleaned Returns: AlphaOnly - nvarchar(max) Syntax: --===== Autonomous SELECT ca.AlphaOnly FROM dbo.AlphaOnly(@pString) ca; --===== CROSS APPLY example SELECT ca.AlphaOnly FROM dbo.SomeTable st CROSS APPLY dbo.AlphaOnly(st.SomeVarcharCol) ca; Programmer's Notes: 1. Based on Jeff Moden/Eirikur Eiriksson's DigitsOnlyEE function. For more details see: 2. This is an iTVF (Inline Table Valued Function) that performs the same task as a scalar user defined function (UDF) accept that it requires the APPLY table operator. Note the usage examples below and see this article for more details: The function will be slightly more complicated to use than a scalar UDF but will yeild much better performance. For example - unlike a scalar UDF, this function does not restrict the query optimizer's ability generate a parallel query plan. Initial testing showed that the function generally gets a 3. AlphaOnly runs 2-4 times faster when using make_parallel() (provided that you have two or more logical CPU's and MAXDOP is not set to 1 on your SQL Instance). 4. CHECKSUM returns an INT and will return the exact number given if given an INT to begin with. It's also faster than a CAST or CONVERT and is used as a performance enhancer by changing the BIGINT of ROW_NUMBER() to a more appropriately sized INT. 5. Another performance enhancement is using a WHERE clause calculation to prevent the relatively expensive XML PATH concatentation of empty strings normally determined by a CASE statement in the XML "loop". 6. Note that AlphaOnly returns an nvarchar(max) value. If you are returning small numbers consider casting or converting yout values to a numeric data type if you are inserting the return value into a new table or using it for joins or comparison purposes. 8. AlphaOnly is deterministic; for more about deterministic and nondeterministic functions see Usage Examples: --===== 1. Basic use against a literal SELECT ao.AlphaOnly FROM dbo.AlphaOnly('xxx123abc999!!!') ao; --===== 2. Against a table DECLARE @sampleTxt TABLE (txtID int identity, txt varchar(100)); INSERT @sampleTxt(txt) VALUES ('!!!A555A!!!'),(NULL),('AAA.999'); SELECT txtID, OldTxt = txt, AlphaOnly FROM @sampleTxt st CROSS APPLY dbo.AlphaOnly(st.txt); --------------------------------------------------------------------------------------- Revision History: Rev 00 - 20170411 - Inital Creation - Alan Burstein ****************************************************************************************/ WITH E1(N) AS (SELECT N FROM (VALUES ($),($),($),($),($),($),($),($),($),($)) x(n)), iTally(N) AS ( SELECT TOP (LEN(ISNULL(@pString,CHAR(32)))) (CHECKSUM(ROW_NUMBER() OVER (ORDER BY (SELECT NULL)))) FROM E1 a CROSS JOIN E1 b CROSS JOIN E1 c CROSS JOIN E1 d ) SELECT AlphaOnly = ( SELECT SUBSTRING(@pString,N,1) FROM iTally WHERE ((ASCII(SUBSTRING(@pString,N,1)) - 65) & 0x7FFF) < 26 OR ((ASCII(SUBSTRING(@pString,N,1)) - 97) & 0x7FFF) < 26 FOR XML PATH('') ); [More »]( Database Pros Who Need Your Help Here's a few of the new posts today on the forums. To see more, [visit the forums](. --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Administration]( [In-Memory Table Alter fails]( - Created an In-Memory demo db to play with in SQL Server 2016 SP1, and I am getting a failure each... [A little tale and a seven questions about SQL partition]( - The tale Once up a time a small software shop had a application used Firebird DBMS. The small shop managed to do... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Development and T-SQL]( [SSIS trace end of iteration in container]( - In SSIS I have a container with a few tasks inside. The container iterates through a rowset or files (does... --------------------------------------------------------------- [SQL Server 2014]( : [Administration - SQL Server 2014]( [Deadlock with two update statements]( - Hi Guys, I am getting a deadlocks recently on one of my instance of SQL Server. Below are the two statements... --------------------------------------------------------------- [SQL Server 2014]( : [Development - SQL Server 2014]( [Function return values]( - I have a function that returns a table of values and i like a way to list those values in... --------------------------------------------------------------- [SQL Server 2012]( : [SQL 2012 - General]( [unexplainable perfomance]( - We are currently experiencing  some strange phenomenons, and I am hoping that someone may be able to shed some light... [creating new partition files on table]( - hello all,  I have a table that has 2,948,231,398 billion rows...I know...last week I had to figure out how to... [Clone Sql-Server complete]( - Hi, we would like our SQL Server 2012 (production server) clone, to have a test server. It must be transferred about... [SQL Server 2012 Exam 70-462 practice questions]( - Hi guys, I'm currently studying for the 70-462 exam using the Administering Microsoft® SQL Sever® 2012 Databases. i have been through... --------------------------------------------------------------- [SQL Server 2012]( : [SQL Server 2012 - T-SQL]( [Do you need an order by when selecting TOP N from a clustered index?]( - Lets say you have a table with 2 columns, the first, an identity primary key column, the second a foreign... [Convert name field from Colunm1: FirstName LastName to Column2 as LastName, FirstName]( - I have a column FullName with data as follows:   John Doe    Joe Doe   Jane Doe I want a result in a new... --------------------------------------------------------------- [SQL Server 2008]( : [T-SQL (SS2K8)]( [calculate previous month]( - please tell me how to calculate below things: create table months (monthIndex int); create table invoice(invoiceId int, month int) create table lineitems(lid int,... [INSERT INTO, EXCLUDING ONE COLUMN]( - Hi Is there a way I can: INSERT INTO TableA SELECT * FROM TableB but exclude one column from TableB? My TableB has ID which is... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server Newbies]( [SQL 2008 R2 varChar(Max) field not storing all data.. cutting off.]( - I recently moved my database from an older version of MS SQL Express to MS SQL Express 2008 R2. I... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 Administration]( [SQL code works from SSMS but fails from the SQL Job.]( - Hello, The following part of the SQL code works perfectly well from SSMS, but fails when scheduled (SQL Job). SET QUOTED_IDENTIFIER is... [database not restoring to original physical names ndf files in backup]( - Hi All, I have a backup db and running RESTOREFILELISTONLYFROM --------------------------------------------------------------- [Cloud Computing]( : [SQL Azure - Administration]( [One database, two users each in a different data center?]( - Hello, Through listening to the various youtube classes, I heard that we could create a database and have it sitting in... --------------------------------------------------------------- [Reporting Services]( : [Reporting Services]( [parameters list: Allow multiple values not working]( - I have a parameters (drop down list) containing all text values that I built by manually providing the values in... --------------------------------------------------------------- [Data Warehousing]( : [Integration Services]( [Search SSIS intance for specific table name]( - Is there a way to search a SQL2012 Integration Services instance for SSIS jobs that update a specific table? Can I... --------------------------------------------------------------- [Career]( : [Certification]( [70-461]( - Hi, Id like to take this exam and looking for some good prep.. My T-SQL skills are basic at present... This email has been sent to {EMAIL}. To be removed from this list, please click [here.]( If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com. --------------------------------------------------------------- This newsletter was sent to you because you signed up at [SQLServerCentral.com](. Feel free to forward this to any colleagues that you think might be interested. If you have received this email from a colleague, you can register to receive it [here](. --------------------------------------------------------------- This transmission is ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com