6145 1
Check database size in Sql server ( Various Ways explained)
In this article, I have explained, how you can check database size in SQL server using various possible ways, easily.
Type
Article
6123 0
Row constructor in SQL server (Explanation With example)
This article gives a quick explanation about Row constructor (Table value constructor) in SQL server with various usage example
Type
Article
6064 3
Getting error 'A transport-level error has occurred when receiving results from the server.'

When I am trying to Load page of my clients web application, which has shared connection string, I am getting the below error

A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)

...

Type
Question
5958 0
Difference between Stored procedure and function in SQL Server
This article, lists important difference difference between Stored procedure and function in SQL Server after giving brief details about Stored procedures and functions (user-defined functions) in SQL server.
Type
Article
5948 1
Tools to Compare Two SQL Server Database
In this article, I have provided list of various tools which can compare two SQL Server database schema and highlights the difference between the two.
Type
Article

5877 0
Download AdventureWorks Database and Restore in SQL server (Step by Step)
In this article, I am going to provide steps to download AdventureWorks sample database and restore in SQL server to do sample tasks or learn SQL server with this AdventureWorks sample database.
Type
Article
5711 1
How to get the records of last month using sql query in SQL server?

Hello, I need to check my last month records in SQL server management studio, and I would like to know how can I get record of only last month from a table using SQL query, I have DateCreated column to check when the row was added in the table.

For example, as It's may,2018 and I would like to run a Query to get April,2018 records using sql server query.

If possible, I would also like to know, how to get last 30 days(not month) records in SQL server query.

Currently, I am using SQL server 2012.

...
Type
Question
5595 2
Not able to start SQL server browser in windows

Today, I was trying to Start my SQL server browser using SQL server configuration manager in windows 10, but I cannot see any option to start it as it is blurred and not clickable, so cannot start SQL server browser, here is the screenshot of my pc

...

Type
Question
5475 0
Creating SQL Server maintenance plan (Step by step procedure)
In this article, I am going to explain, how can we easily create SQL server maintenance plan by following this step by step procedure and how often we should plan it.
Type
Article
5345 1
Download and Install SQL Server (Step by Step procedure)
In this article, I have provided the guide to download and install sql server database on your machine with step by step procedure.
Type
Article

Page 3 of 10