Rename Server Name for SQL Server Cluster | JohnSterrett.com - 0 views
-
Sergey Leifer on 03 May 11Rename Server Name for SQL Server Cluster
Group items tagged
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.
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.
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...
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.
Fundamentals of Storage Systems, IO Latency and SQL Server - 1 views
-
Fundamentals of Storage Systems, IO Latency and SQL Server
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.
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.
Introduction to SQL Server Proactive Caching - DatabaseJournal.com - 0 views
Ten SQL Server Functions That You Hardly Use But Should - 0 views
A closer look at CXPACKET wait type in SQL Server - 0 views
-
If you have a server that has more than one CPU core, you may experience high values of CXPACKET wait types. This is typically due to queries that run in parallel and the real issue is to understand how different versions of a query can impact CXPACKET waits...
SQLDiag for SQL Server 2005 - 0 views
-
This article explains how to use SQLDiag as a Service to get more thorough diagnostics than the standard Profiler traces or Server Side Tracing...
Data Type Mapping - 0 views
-
ADO Data Type mapping between Visual Basic, Access, SQL Server, Oracle, and the .NET Framework.
How to Find Corrupt Records of The Pages - 1 views
-
Say one of the pages in your table is corrupt and while repairing the corrupt pages, you may eventually end up loosing some data. You may want to find out which records are on the page.
SSAS performance counters - 0 views
SSAS performance counters * Direct hit ratio - Ratio of cache direct hits to cache lookups, for the period between obtaining counter values. Higher is better. * Evictions / sec - Rate of evictio...
Automating Analysis Services Deployment - 0 views
Automating build of Analysis Services Projects As you may be aware, an Analysis Services project consists of the following files: A project file (*.dwProj) One or more Data sources (*.ds) One or...
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...