Top 50 .Net Framework Interview and General FAQs....
Q 1 What Is CLR?
CLR is a runtime environment. Code that we develop with language compiler that targets the runtime...
2014-04-16
1,549 reads
Querying Microsoft SQL Server
What is Program Database?
If you are working with .Net then you will be aware about PDB files.A PDB file is a Program Database,that is...
2014-04-01
713 reads
Querying Linked Server without OPENQUERY
I already post an article how to setup Linked Server in SQL Server and querying on linked Server using open...
2014-02-14
77,041 reads
Wishing all visitors a very happy new year 2014
Wishing all visitors
A Very Happy & Prosperous
New Year 2014
Happy New Year! Thanks to visit queryinqsql.com.
Last year I started this Blog,and post...
2013-12-30
1,455 reads
Understanding SQL Server related Windows Registries
SQL Server related information from Windows registries
The Windows Registry is a hierarchical database that stores configuration settings and options on Microsoft Windows operating systems. It contains...
2013-11-30
2,174 reads
9 points before backing up SQL Server databases
Backing up SQL Server Databases
Backing up your SQL Server database is essential for protecting your data. The word Backup refers...
2013-11-23
3,193 reads
Querying Microsoft SQL Server: T-SQL
Querying Microsoft SQL Server: T-SQL: T -SQL is advancement of SQL. It include procedural programming, local variables , various support functions for...
2013-11-14
1,170 reads
Interview FAQ on Interface in C#
What is Interface?
An interface is collection of methods, properties, indexers and events with only signatures. Means In interface Methods, properties,...
2013-10-29
1,565 reads
SQL Server Inetrview FAQ 3
1. How to find the maximum no of connection allowed in SQL Server?
Select@@MAX_Connections
2. How to select top 2 rows without...
2013-10-24
1,082 reads
Cumulative SUM in SQL Server
Sometimes we need to find sum of first and next row in cumulative way.
Create table and insert data:
CREATE TABLE [dbo].[testsum](
...
2013-10-25 (first published: 2013-10-19)
41,452 reads
Blogs
Query multiple Azure SQL Databases
I was sick of changing context in Azure Data Studio while cleaning up things...
KDA: Echoes of Deception - Case 3
By Zikato
The crime spree in Digitown is not ending. This time 20 cars have been...
The Book of Redgate: Do Your Best Work
By Steve Jones
One of our mission statements in the Book of Redgate says: attempt to do...
Forums
Sustainable Procurement Best Practices for ESG-Driven Supply Chains
In today’s business world, Environmental, Social, and Governance (ESG) criteria are no longer optional. Customers, investors,...
Shining a Light on Shadow AI - Responsible Data Protection When AI is Everywhere
Comments posted to this topic are about the item Shining a Light on Shadow...
CAST(VARCHAR(n)) resolved performance issue?
Hi, I would love to hear if anyone can tell me why a CAST...
Question of the Day
The Internals of Writing a Page
In SQL Server, when the buffer manager write pages to disk, page protection is added to the pages. There are two types of protection: torn page protection and checksum page protection. What happens with regards to concurrency with page protection during writes?
See possible answers