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,555 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
726 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,159 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,458 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,184 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,204 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,176 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,576 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,093 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,460 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers