SQL SERVER - Data types
In relational database, we store data in tabular form where data is divided into columns. Each column has a name...
2015-01-25
872 reads
Profiling Entity Framework 6 Queries
Entity Framework 6 introduced some API hooks that you can use to monitor log queries that Entity Framework is generating...
2015-01-25
263 reads
Script for compressing a database
When you have to compress a database you’d better first see the consideration for the compression. This is a script that I use for compressing databases. Of course you...
2015-01-24
13 reads
Script for compressing a database
When you have to compress a database you’d better first see the consideration for the compression. This is a script that I use for compressing databases. Of course you...
2015-01-24
25 reads
Script for compressing a database
When you have to compress a database you’d better first see the consideration for the compression.
This is a script that...
2015-01-24
407 reads
SQL Server - Convert() function
Convert () function in SQL Server to convert an expression from one data type to another data type
Syntax for CONVERT function
CONVERT ( data_type [ ( length ) ] , expression...
2015-01-24
1,887 reads
Compress that database
When you have to compress a database you'd better first see the considerationfor the compression.This is a script that I...
2015-01-24
71 reads
Video: A Better Way to Reindex
Sean presented A BETTER WAY TO REINDEX for the Performance Virtual Chapter. Here are links to the video, and to...
2015-01-23
1,946 reads
I’m A Friend Of Red Gate For 2015
I was excited to learn this week that I’ve been chosen as a participant in the Friends of Red Gate...
2015-01-23
568 reads
Friday Followup For January 23, 2015
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2015-01-23
485 reads
Blogs
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
SQL Server Audit Failures
Comments posted to this topic are about the item SQL Server Audit Failures
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers