Querying Microsoft SQL Server : Control Statements in T-SQL
Querying Microsoft SQL Server : Control Statements in T-SQL: Control statements are used to control execution flow within a T-SQL.Here I...
2013-03-13
757 reads
Querying Microsoft SQL Server : Defining Variables
Querying Microsoft SQL Server : Defining Variables: Defining Variables in SQL Server: Like other programming languages T-SQL allows to defining your...
2013-03-13
852 reads
Top BI Enhancements for SQL Server 2012 Presentation Slides
Thanks to everyone who attended my session “Top BI Enhancements for SQL Server 2012” at the Houston Area SQL Server User Group Monthly Meeting.
Here...
2013-03-13
1,005 reads
T-SQL Tuesday #40– File and Filegroups
It’s the second Tuesday of the month and time for T-SQL Tuesday again. This is a monthly blog party, where...
2013-03-15 (first published: 2013-03-12)
2,861 reads
SQL Server : Index Part 3 :Explaining the Clustered Table Structure
In SQL server, there are two types of table based on the storage.A table with clustered index is called Clustered...
2013-03-12
2,892 reads
Parallel Data Warehouse (PDW) Version 2
Version 2 of Parallel Data Warehouse (PDW) is apparently due this month (and can be ordered as of March 1st). The official...
2013-03-12
2,718 reads
SQL RAP
Technorati Tags: SQL Nexus,SQLDiag,PSSDiag,PAL,SQL RAP,SQL Server 2012,SQL Server 2005,SQL Performance
About one year ago I had a Microsoft Premier Field Engineer...
2013-03-12
7,881 reads
SSIS 2012 Deadlock When Running SSIS from SQL Agent Job
I recently had an interesting situation where an SSIS package was scheduled to run at 1 AM but failed with...
2013-03-18 (first published: 2013-03-12)
5,083 reads
Building My Next Workstation–Part 6 (The End)
Let’s start with a quick review of the pieces and what I paid:
ItemCostAntec P280 Case$90 (may be higher now)ASUS P8Z77-V...
2013-03-12
668 reads
Do You Know sys.dm_exec_text_query_plan?
One of the most fundamental DMF’s a SQL Server DBA should know is sys.dm_exec_query_plan.
This Dynamic Management Function allows us to see...
2013-03-19 (first published: 2013-03-12)
2,809 reads
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers