Skip to main content

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

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
Hostforlife Hosting

How to Get CONSTRAINT of Database or Table - 1 views

europeanwindowshosting.hostforlife.eu/...AINT-of-Database-or-Table.aspx

sql server hosting tutorial mssql

shared by Hostforlife Hosting on 22 Jun 15 - No Cached
  • Hostforlife Hosting on 22 Jun 15
     
    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

Input Note - 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

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

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...

SQL Server Analysis Services

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

Automating Analysis Services Deployment - 1 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...

SQL Server Analysis Services Management

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

How to: Connect to the Database Engine Using sqlcmd.exe - 0 views

msdn.microsoft.com/...ms188247.aspx

SQL Server

shared by Sergey Leifer on 15 Feb 11 - No Cached
  • Sergey Leifer on 15 Feb 11
     
    How to: Connect to the Database Engine Using sqlcmd.exe
Hostforlife Hosting

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

europeanwindowshosting.hostforlife.eu/...andle-Error-in-SQL-Server.aspx

mssql sql server tutorial sql database

shared by Hostforlife Hosting on 29 Jun 15 - No Cached
  • Hostforlife Hosting on 29 Jun 15
     
    This tutorial talks about how to handle error in SQL Server using THROW.
Sergey Leifer

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...

SQL Server Analysis Services

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

MSOLAP Service Crashes Once a Day - Windows Low Fragmentation Heap vs OLAP Heap - 0 views

jesseorosz.spaces.live.com/...cns!E322FD91218E57CF!295.entry

SQL Server Analysis Services

shared by Sergey Leifer on 11 Aug 10 - Cached
  • Sergey Leifer on 31 Aug 10
     
    OLAP Heap isn't an stable as Windows, especially if you have a large OLAP database (we're 500GB and I guess that's considered large)...
Sergey Leifer

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...

SQL Server Analysis Services Monitoring

started by Sergey Leifer on 02 Sep 10 no follow-up yet
1 - 11 of 11
Showing 20▼ items per page