Showing posts with label SQL Server Express 2008 R2 SP1. Show all posts
Showing posts with label SQL Server Express 2008 R2 SP1. Show all posts
Wednesday, April 24, 2024

Understanding Indexing in SQL Server: Types and Usage

›
What is an Index?    An index in SQL Server is a data structure associated with a table or view that speeds up the retrieval of rows based...
Thursday, December 01, 2022

How to check active transactions in SQL Server

›
A transaction is a single unit of work. If a transaction is successful, all of the data modifications made during the transaction are commit...
Thursday, April 25, 2019

SQL SERVER – How to find table rows count?

›
At some point in time we’ve all had to find out how many rows are in a table. The first answer you’ll usually get when you ask someone how t...
Wednesday, January 23, 2019

Get Current TimeZone Name in SQL Server

›
Here is how we can get current time zone from sql server DECLARE @TimeZone VARCHAR(50) EXEC MASTER.dbo.xp_regread 'HKEY_LOCAL_MACHINE...
Tuesday, August 07, 2018

Quick note: How to get backup history of a database?

›
Here is how you can get via SQL Query, This works on any SQL Server version USE database_name GO -- Get Backup History for required datab...
Wednesday, June 13, 2018

'TRUNCATE_ONLY' is not a recognized BACKUP option.

›
In Microsoft SQL server 2000 and 2005, as part of the ‘BACKUP LOG’ command, there was an option to truncate the log file, without storing a ...
Friday, June 08, 2018

Determining which version and edition of SQL Server Database Engine is running

›
Open SQL Server Management Studio (SSMS) and connect to SQL Server. Run below query to find version and edition of SQL server. SELECT ...
Thursday, May 31, 2018

OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error"

›
OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "Unspecified error or ole db...
Wednesday, May 16, 2018

Configure the remote query timeout Server Configuration Option

›
Use below query to increase default time out or disable time out time. USE ps; GO EXEC sp_configure 'remote query timeout' , 0...
Monday, April 30, 2018

SSMS: Index was outside the bounds of the array. (Microsoft.SqlServer.Smo)

›
We will see this when we connect to SQL Server 2012 from SQL Server 2008/2008 R2 Cause This issue occurs because of an error in SSMS 2008 R...

Quick Note: How to find out which Service Pack is installed on SQL Server?

›
-- SQL Server 2000/2005/2008/2008R2/2012 SELECT SERVERPROPERTY ( 'productversion' ), SERVERPROPERTY ( 'productlevel' ),...
Thursday, March 22, 2018

How to get size of all tables in database

›
Here is how you can get table sizes via SQL query, this works from SQL 2005 and above SELECT t . NAME AS TableName , s . Name ...
Thursday, March 01, 2018

How to Get First and Last Day of a Year from SQL

›
Here is how we get first day and last day of the year. DECLARE @ Year int set @ Year = 2018 select DATEADD( year ,0,DATEADD( year ,@...
Sunday, November 27, 2016

EXCEPT and INTERSECT in T-SQL

›
The UNION, EXCEPT and INTERSECT operators of SQL enable you to combine more than one SELECT statement to form a single result set. The UNION...
Monday, June 25, 2012

Download: Microsoft® SQL Server® 2008 R2 SP1 - Express Edition

›
Microsoft SQL Server 2008 R2 Express with Service Pack1 is a free, feature-rich edition of SQL Server that is ideal for learning, developing...