Microsoft SQL Server Management Studio
51 views | +0 today
Follow
Your new post is loading...
Your new post is loading...
Scooped by Edwin Ong
Scoop.it!

SQL Server Indexed Views: The Basics - Simple Talk

SQL Server Indexed Views: The Basics - Simple Talk | Microsoft SQL Server Management Studio | Scoop.it
Views are a valuable tool for the SQL Server Developer, because they hide complexity and allow for a readable style of SQL expression. They aren't there for reasons of performance, and so indexed views are designed to remedy this shortcoming. They're great in certain circumstances but they represent a trade-off, and they come with considerable 'small print'. Jes Borland explains.
more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

Log Activity with sp_whoisactive - Brent Ozar Unlimited®

Log Activity with sp_whoisactive - Brent Ozar Unlimited® | Microsoft SQL Server Management Studio | Scoop.it
@destination_table = 'WhoIsActive_' + CONVERT(VARCHAR, GETDATE(), 112) ;
SET @dSQL = N'SELECT collection_time, * FROM dbo.' +
QUOTENAME(@destination_table) + N' order by 1 desc' ;
print @dSQL
EXEC sp_executesql @dSQL
more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

How to Use sp_WhoIsActive to Find Slow SQL Server Queries - Brent Ozar Unlimited®

How to Use sp_WhoIsActive to Find Slow SQL Server Queries - Brent Ozar Unlimited® | Microsoft SQL Server Management Studio | Scoop.it
Download this free replacement for sp_who and sp_who2 that gets you much more information like execution plans and full queries.
more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

sql - Why can't I use alias in a count(*) "column" and reference it in a having clause? - Stack Overflow

sql - Why can't I use alias in a count(*) "column" and reference it in a having clause? - Stack Overflow | Microsoft SQL Server Management Studio | Scoop.it
more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

SQL SERVER - What is Page Life Expectancy (PLE) Counter

SQL SERVER - What is Page Life Expectancy (PLE) Counter | Microsoft SQL Server Management Studio | Scoop.it
During performance tuning consultation there are plenty of counters and values, I often come across. Today we will quickly talk about Page Life Expectancy counter, which is commonly known as PLE as...
more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview,SQL Server,Ajax,SSRS, XML examples: SQL Server

ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview,SQL Server,Ajax,SSRS, XML examples: SQL Server | Microsoft SQL Server Management Studio | Scoop.it
ASP.NET,C#.NET,VB.NET,JQuery,JavaScript,Gridview,SQL Server,Ajax,jQuery Plugins,jQuery UI,SSRS,XML,HTML,jQuery demos,code snippet examples
more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

Snapshot vs. LogShipping vs. Mirroring vs. Replication vs. Failover Clustering

Snapshot vs. LogShipping vs. Mirroring vs. Replication vs. Failover Clustering | Microsoft SQL Server Management Studio | Scoop.it
All these SQL SERVER terms were quite confusing for me. Luckily, I got to attend Vinod's session last Saturday at BDOTNET's UG meet. So I am going to jot down my understanding of them, & will l...
more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

Simple Query tuning with STATISTICS IO and Execution plans

Simple Query tuning with STATISTICS IO and Execution plans | Microsoft SQL Server Management Studio | Scoop.it
A great deal can be gleaned from the use of the STATISTICS IO and the execution plan, when you are checking that a query is performing properly. Josef Richberg, the current holder of the 'Exceptional DBA' award, explains how an apparently draconian IT policy turns out to be a useful ways of ensuring that Stored Procedures are carefully checked for performance before they are released
more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

Querying SQL Server Agent Job Information

Querying SQL Server Agent Job Information | Microsoft SQL Server Management Studio | Scoop.it
I am a BI developer and have been moved recently to a DBA role.
more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

See what queries are currently running - SQLMatters

See what queries are currently running - SQLMatters | Microsoft SQL Server Management Studio | Scoop.it
Sometimes it is useful to see what is currently running on a SQL server. On SQL Server 2005 and later this is fairly easy to achieve using the Dynamic Management View (DMV) dm_exec_requests.
more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

SQL SERVER - Introduction to Change Data Capture (CDC) in SQL Server 2008

SQL SERVER - Introduction to Change Data Capture (CDC) in SQL Server 2008 | Microsoft SQL Server Management Studio | Scoop.it
Simple-Talk.com has published my very first article on their site. This article is introducing Change Data Capture - the new concept introduced in SQL Server 2008. Change Data Capture records INSER...
more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

Scans vs. Seeks - Craig Freedman's SQL Server Blog - Site Home - MSDN Blogs

Scans vs. Seeks - Craig Freedman's SQL Server Blog - Site Home - MSDN Blogs | Microsoft SQL Server Management Studio | Scoop.it
more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

SQL Server Solutions with Practical SQL DBA: SQL Server - Index Fragmentation - Understanding Fragmentation

SQL Server Solutions with Practical SQL DBA: SQL Server - Index Fragmentation - Understanding Fragmentation | Microsoft SQL Server Management Studio | Scoop.it
Index Fragmentation
more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

ASP.NET Threads – Thread Parameters in IIS Worker Processes

ASP.NET Threads – Thread Parameters in IIS Worker Processes | Microsoft SQL Server Management Studio | Scoop.it
  This post is to help you to understand ASP.NET thread parameters, and describe definitions, how-to check & how-to edit. Thread Parameters of .NET Applications can be a different topic. T...
more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

Setting up SQL Linked Server to SSAS and Avoiding Kerberos Double-Hop in RedGate

Setting up SQL Linked Server to SSAS and Avoiding Kerberos Double-Hop in RedGate | Microsoft SQL Server Management Studio | Scoop.it
Wow...that's a long blog post title.  First off, here are a few scripts that will show information about linked servers on the instance of SQL you’re connected to, create a linked server connection...
more...
No comment yet.
Scooped by Edwin Ong
Scoop.it!

SELECT * FROM XML

SELECT * FROM XML | Microsoft SQL Server Management Studio | Scoop.it
One of the most common problem SQL Server developers face while dealing with XML is related to writing the correct XPath expression to read a specific value from an XML document. I usually get a lo...
more...
No comment yet.