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
2,016 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
7 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,839 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
3 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...
2018-06-15
34,984 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
205 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,890 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
12 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...
2018-06-02
1,580 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
11 reads
Blogs
Azure Networking: Designing for Change
By John
Failing to plan is planning to fail. When organizations first begin implementing Azure networking,...
Using Customer Docker Compose File Names
By Steve Jones
As I use containers more and more to run various things, I decided I...
SQL Server Failover Cluster Instances
By Kevin3NF
Old Reliable Still Matters If you’ve been around SQL Server for a while, you’ve...
Forums
SQL Server authentication vs. Trusted connection
I maintain an application written years ago, where the database is on a Windows...
Handling Engagement Rings & Wedding Band
I’m working on a jewelry e-commerce project and need advice on designing an efficient...
The Duplicate Cursor
Comments posted to this topic are about the item The Duplicate Cursor
Question of the Day
The Duplicate Cursor
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers