Know How Table Variables Different From Temporary Tables in SQL Server
Know What Table Variables are ?
SQL Server support features that allow users to work with temporary data that gets stored...
2018-07-18
1,870 reads
SQL Server Overview
Know How Table Variables Different From Temporary Tables in SQL Server
Know What Table Variables are ?
SQL Server support features that allow users to work with temporary data that gets stored in temporary tables. Microsoft introduced table variables for the...
2018-07-18
1 reads
How Often Should I Backup my Database - Query Answered
"In recent time, some of our counterpart organizations have faced database corruption. Though our company takes backup every week, we...
2018-06-18
2,706 reads
How Often Should I Backup my Database - Query Answered
"In recent time, some of our counterpart organizations have faced database corruption. Though our company takes backup every week, we have decided to become more careful. I would like...
2018-06-18
How to Read BLOB data in SQLite in an Efficient Way
SQLite is one of the most commonly used database engine. Its source code is available in public domain which can...
2018-06-15
30,782 reads
How to Read BLOB data in SQLite in an Efficient Way
SQLite is one of the most commonly used database engine. Its source code is available in public domain which can be used for commercial or private purpose. Common data...
2018-06-15
180 reads
Understanding the Role of SQL Server Agent in SQL Server
SQL Server Agent is a component of Microsoft SQL Server that is responsible to execute & schedule tasks or jobs in...
2018-06-06
3,260 reads
Understanding the Role of SQL Server Agent in SQL Server
SQL Server Agent is a component of Microsoft SQL Server that is responsible to execute & schedule tasks or jobs in SQL Server. It runs as a Windows service...
2018-06-06
Microsoft SQL Server Analysis Services and Its Synchronization
SQL Server Analysis Services (SAAS) serves a broader view of data for analysis so as to make things simpler for...
2018-06-02
1,495 reads
Microsoft SQL Server Analysis Services and Its Synchronization
SQL Server Analysis Services (SAAS) serves a broader view of data for analysis so as to make things simpler for business analysts. Implementation of SAAS gives an opportunity to...
2018-06-02
Blogs
Extended Events in Azure Data Studio
I know I can use extended events (xevents) in Azure SQL DB when in...
Azure Workbooks
I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...
SQL Prompt Tips–Using $surroundtext$ in a Snippet
By Steve Jones
A user on the SQL Community Slack was asking about what the $surroundtext$ variable....
Forums
Reduction of installation time of sql server 2008 R2 Express
The installation of SQL Server 2008 R2 Express on a virtual machine takes around...
Creating Aggregates
Comments posted to this topic are about the item Creating Aggregates
Getting Started with DDL statements of Cassandra Query Language
Comments posted to this topic are about the item Getting Started with DDL statements...
Ask SSC