Skip to main content

Home/ MS SQL Server and Analysis Services/ Group items tagged SQL Server

Rss Feed Group items tagged

Hostforlife Hosting

How to Use THROW to Handle Error in SQL Server - 1 views

  •  
    This tutorial talks about how to handle error in SQL Server using THROW.
Sergey Leifer

Rename Server Name for SQL Server Cluster | JohnSterrett.com - 0 views

  •  
    Rename Server Name for SQL Server Cluster
Hostforlife Hosting

New Features that You Should Know in SQL Server 2016 - 1 views

  •  
    Microsoft has been released the latest version of SQL Server 2016. Here's a rundown of our most favourite new features in SQL Server 2016.
Sergey Leifer

How to reduce paging of buffer pool memory in the 64-bit version of SQL Server - 1 views

  •  
    ... SQL Server can use the memory notification mechanisms that are provided by the QueryMemoryResourceNotification Windows API. On a Microsoft Windows 2000 Server-based system, SQL Server periodically calculates the free physical memory on the system by using the native Windows API. Based on this information from the QueryMemoryResourceNotification Windows API or from the memory calculation, SQL Server responds to the current memory situation on a specific system...
Hostforlife Hosting

How to Create a Date List from a Date Range in SQL Server - 1 views

  •  
    In this post, we will convert a given date of range into list of dates as per the business requirement.
Hostforlife Hosting

How to Search Similar String in One Table - 1 views

  •  
    There are may ways to look for similar strings in a SQL Server column. The most common method is to make use of LIKE operator. Let us see the different ways to look for similar string in a table.
Sergey Leifer

Fundamentals of Storage Systems, IO Latency and SQL Server - 1 views

  •  
    Fundamentals of Storage Systems, IO Latency and SQL Server
Sergey Leifer

T-SQL: find SQL TCP port number - 0 views

--SQL 2000/2005 Version set nocount on go DECLARE @SqlPort Nvarchar(10) DECLARE @instance_name Nvarchar(30) DECLARE @reg_key Nvarchar(500) Declare @value_name Nvarchar(20) if left(CAST(SERVERPROP...

SQL Server T-SQL

started by Sergey Leifer on 07 Aug 10 no follow-up yet
pparada

understanding SQL statistics - 1 views

http://www.sqlbitsandpieces.com/category/learn-sql/statistics-learn-sql/

sql server

started by pparada on 23 Sep 14 no follow-up yet
Sergey Leifer

T-SQL: search by tags - 0 views

DECLARE @filter TABLE (id INT IDENTITY, data nvarchar(32)) insert into @filter (data) values ('sql,performance') insert into @filter (data) values ('profiler') insert into @filter (data) values ...

SQL Server T-SQL

started by Sergey Leifer on 07 Aug 10 no follow-up yet
Hostforlife Hosting

How to Get CONSTRAINT of Database or Table - 1 views

  •  
    In this post, we are going to explain how you can list all CONSTRAINT of database or table in SQl Server. When you are working on database sometimes you need to check or get the CONSTRAINT on database or table. Using below given query we can get the CONSTRAINT of table or database quickly.
Sergey Leifer

TSQL - Script for moving databases to a new location - 0 views

set nocount on declare @SqlInstanceName varchar(128), @SqlServiceName varchar(128), @Cmd varchar(8000), @TempDbLoc varchar(255), @SysDbLoc varchar(255), @UserDbDataLoc varchar(255), @U...

SQL Server Management SQL2000 SQL2008

started by Sergey Leifer on 21 Sep 10 no follow-up yet
Sergey Leifer

Data Type Mapping - 0 views

  •  
    ADO Data Type mapping between Visual Basic, Access, SQL Server, Oracle, and the .NET Framework.
1 - 20 of 63 Next › Last »
Showing 20 items per page