data-konzept

'Create the stored procedure using the script. Then run it by asking the Magic8Ball a question.'...

http://www.sqlservercentral.com/scripts/fun/126517/

'Dear Customers,

The refreshed 6th cumulative update release for SQL Server 2014 SP1 is now available for download at the Microsoft Support site.

To learn more about the release or servicing model, please visit:

• Updated CU#6 KB Article: https://support.microsoft.com/en-us/kb/3167392

• Deprecated CU#6 KB Article: https://support.microsoft.com/en-us/kb/3144524

  • KB 3144524 describes the deprecated (no longer available) Cumulative Update (CU) 6 (Build number: 12.0.4449.0) for Microsoft SQL Server 2014 Service Pack 1 (SP1). If you already downloaded and installed this older CU6 package, Microsoft recommends that you install the updated CU6 build (12.0.4457.0) as soon as possible.

  • To find the current version of SQL Server that you have installed, see How to determine the version, edition and update level of SQL Server and its components.

• Understanding Incremental Servicing Model for SQL Server

• SQL Server Support Information: http://support.microsoft.com/ph/2855

• Update Center for Microsoft SQL Server: http://technet.microsoft.com/en-US/sqlserver/ff803383.aspx

Original post date: Apr 19, 2016

Updated on: May 31, 2016'...

https://blogs.msdn.microsoft.com/sqlreleaseservices/cumulative-update-6-for-sql-server-2014-sp1/

More infos about the problem of the original CU6 release...

https://www.brentozar.com/archive/2016/05/breaking-news-literally-2014-sp1-cu6-breaks-nolock/

'This is a small SQL Function which will be useful for querying a Table which is having a comma separated value Column'...

http://www.codeproject.com/Tips/1101816/How-to-Query-Comma-Seperated-Value-Column-in-SQL

'Most database professionals avoid Kerberos like, well, the three-headed guard dog, Cerberus, that the technology is named after. Most DBAs don’t have the permissions to change the settings in Active Directory (AD) that affect Kerberos, but I believe that DBAs should understand Kerberos authentication so that they can help troubleshoot issues that come up.'...

http://blog.sqlauthority.com/2016/05/26/sql-server-dbas-need-know-kerberos-notes-field-126/

'In this post we’re going to introduce the basics of CPU scheduling.

In a computer system, only one thing can happen at a time. More specifically, only one task can be on a processor at a point in time. This can expand to several tasks if the system has multiple processors or a processor with multiple cores, which most modern systems have. For example, a four core system can potentially execute four tasks concurrently. 

So since only one task can be on a logical processor (or core) at one point in time, something has to manage which task gets access to the CPU. This is what the scheduler does. CPU scheduling is a very (VERY) deep topic and I’m going to introduce you to a couple basic concepts that can help you understand how scheduling works in Windows and SQL Server. So when you see things slow down in either of one of these technologies you know where you can start to look first.'...

http://www.centinosystems.com/blog/sql/cpu-scheduling-basics-windows-and-sql-server/

'TRUNCATE TABLE in SQL Server is well known for what it does as feature, but how it actually works is easily misunderstood, and for long time, the same wrong information goes on and on. 

Today’s post wants to show you some of those misconceptions and why they are untrue using demos anyone can go reproduce.'...

http://www.sqldoubleg.com/2016/05/25/truncate-table-misconceptions/

'This function is used to get the unused stored procedure list for which doesn't used for given noofdays.'...

http://www.sqlservercentral.com/scripts/Unused+procedure/119492/

'In SQL Server, the classic stored procedures that we know and love are interpretive. This means that when a stored procedure is executed for the first time, the SQL Server relational engine first compiles it, and then executes it. By contrast, when we create a natively compiled stored procedure, SQL Server compiles it into machine code immediately, and stores it in a DLL.

Since the stored procedure is now expressed in machine code, the CPU can run it directly, without any interpretation. The lack of interpretation means that the resulting code will be much simpler and more efficient than our standard stored procedures.

Natively compiled stored procedures can reference only in-memory tables. This, for most people, will be the biggest "barrier to entry". The time and effort needed to convert old tables into In-Memory OLTP tables can be significant. For example, foreign keys are not allowed in In-Memory tables, which may be problematic for a highly relational environment. In addition, there are many other restrictions on the T-SQL that is allowed inside a natively compiled stored procedure, compared to classic stored procedures.

As such, it's typically a good idea to save in-memory OLTP, as well as in-memory stored procedures for applications where speed and efficiency are of the utmost importance. However, for those tables and procedures that you can move to in-memory, you will often see a huge improvement in performance over standard disk-based stored procedures.'...

http://www.sqlservercentral.com/articles/SQL+Server+2014/111460/

'It’s been about a year and a half since I last posted an update to my script that scans databases for objects to compress and, optionally, compresses them. This time around, I’ve just incorporated a bug fix and added a check to make sure the script is running on an edition of SQL Server that supports compression – namely Enterprise or Developer.'...

http://shaunjstuart.com/archive/2015/10/enabling-data-compression-october-2015-update/

'How do you go about transferring a disk-based workload to the respective memory-optimized design? How do you process memory-optimized tables? How important for performance are natively-compiled Stored Procedures? Artemakis Artemiou comes up with a step-by-step guide to implementing an in-memory OLTP solution .'...

https://www.simple-talk.com/sql/learn-sql-server/implementing-sql-server-in-memory-oltp/