DotNetShoutout - Stories tagged with TSQL

TSQL

atom rss
8
Shouts
spam Shout it Mute it

Central Management Servers register error in SQL Server 2008 - "Can not add a shared registered server with the same name as configuration Server"
published 507 days, 6 hours, 6 minutes ago posted by kinj312kinj312 510 days, 6 hours, 48 minutes ago
Monday, January 02, 2012 10:33:49 AM GMT Friday, December 30, 2011 9:52:37 AM GMT
You may know how can we register SQL Server instances with Central Management Servers (CMS) and also how can we perform multi server query will all of instances of registered SQL Server instances. There you can see i have registered one shared SQL Server... (more)
category: Data | clicked: 4 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

SSIS #103 – Learn SSIS NOW
published 507 days, 6 hours, 6 minutes ago posted by dharadhara 511 days, 6 hours, 9 minutes ago
Monday, January 02, 2012 10:33:49 AM GMT Thursday, December 29, 2011 10:30:55 AM GMT
When I wrote the blog SSIS # 102 – Don’t be afraid to leverage TSQL in SSIS package , it was purely “inspired” by an ETL design I was working on during the day, and also an SSIS training piece I was reading from Pragmatic Works... (more)
category: Data | clicked: 12 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, SSIS, BI
10
Shouts
spam Shout it Mute it

Reduce heap table fragmentation
published 507 days, 6 hours, 6 minutes ago posted by kinj312kinj312 512 days, 5 hours, 36 minutes ago
Monday, January 02, 2012 10:33:49 AM GMT Wednesday, December 28, 2011 11:04:15 AM GMT
A table that does not have a clustered index is referred to as a Heap. While a lot has been written about index fragmentation and how to defrag indexes, there is not much that talks about how to defrag a heap table. To identify whether your heap table... (more)
category: Data | clicked: 14 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, Database
9
Shouts
spam Shout it Mute it

Find out the referenced tables of a table that to be added as articles in replication
published 507 days, 6 hours, 6 minutes ago posted by dharadhara 513 days, 4 hours, 48 minutes ago
Monday, January 02, 2012 10:33:49 AM GMT Tuesday, December 27, 2011 11:52:08 AM GMT
In replication, we need to add objects as articles to replicate the data to different server.The important point is here that if we have any reference(foreign keys) associated with the articles(tables choosen to be replicated), then we need to consider... (more)
category: Data | clicked: 25 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, Database
11
Shouts
spam Shout it Mute it

Day 7: Unpivot using UNNEST function in PostgreSQL
published 511 days, 15 hours, 28 minutes ago posted by kinj312kinj312 514 days, 8 hours, 1 minute ago
Thursday, December 29, 2011 1:12:25 AM GMT Monday, December 26, 2011 8:39:22 AM GMT
UnNest function in PostgreSQL In PostgreSQL, we can perform UnPivoting using the UnNest function. It accepts an array and expands the array items in set of rows. Syntax: UNNEST(Some array) Example Let us consider the below script Create Table tblUnPivotExample... (more)
category: Data | clicked: 13 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
9
Shouts
spam Shout it Mute it

SQL Server – T-SQL - Best Practice - Composite Primary Keys – Performance (and accuracy) impact
published 511 days, 15 hours, 28 minutes ago posted by kinj312kinj312 514 days, 8 hours, 1 minute ago
Thursday, December 29, 2011 1:12:25 AM GMT Monday, December 26, 2011 8:38:49 AM GMT
One of the reasons I enjoy working with Microsoft SQL Server because often I find that its behaviour is a classic case of GIGO (Garbage In Garbage Out). Jacob Sebastian ( blog ) always makes it a point to mention in his TechEd and Community Tech Days... (more)
category: Data | clicked: 39 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

Day 6: Common Table Expressions using WITH clause in PostgreSQL
published 513 days, 7 hours, 34 minutes ago posted by dharadhara 516 days, 8 hours, 39 minutes ago
Tuesday, December 27, 2011 9:06:15 AM GMT Saturday, December 24, 2011 8:01:04 AM GMT
Common Table Expression(CTE) is particularly useful when subquery is executed multiple times. It is equally helpful in place of temporary tables.It computes the aggregation once, and allows us to reference it by its name (may be multiple times) in the... (more)
category: Data | clicked: 8 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

Dynamic SQL for Optional Parameters
published 513 days, 7 hours, 34 minutes ago posted by dharadhara 516 days, 8 hours, 39 minutes ago
Tuesday, December 27, 2011 9:06:15 AM GMT Saturday, December 24, 2011 8:00:43 AM GMT
I often see screens or reports that take multiple parameters. Each of those parameters is optional. The code SQL behind those reports often looks like this SELECT COUNT(*) AS Orders SUM(TotalDue) as TotalDue FROM Sales.SalesOrderHeader SOH WHERE (CustomerID... (more)
category: Data | clicked: 15 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

SQL Server 2012: Detecting Sort Warnings with Extended Events (sort_warning event) – Part 2
published 513 days, 7 hours, 34 minutes ago posted by dharadhara 516 days, 8 hours, 40 minutes ago
Tuesday, December 27, 2011 9:06:15 AM GMT Saturday, December 24, 2011 8:00:19 AM GMT
In my last post, SQL Server 2012: Detecting Sort Warnings with Extended Events (sortwarning event) I showed how to use sortwarning event with sql_text action to detect sort warnings in database with statements sent to SQL server instance. We also saw... (more)
category: Data | clicked: 3 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, sql server 2012
8
Shouts
spam Shout it Mute it

SQL server 2012 Startup parameters
published 514 days, 8 hours, 25 minutes ago posted by dharadhara 517 days, 6 hours, 11 minutes ago
Monday, December 26, 2011 8:15:27 AM GMT Friday, December 23, 2011 10:29:12 AM GMT
I’m sure that I’m not the only one with nightmares about the startup parameters in older versions of SQL Server 200x – the design and UI is just bad, it is so easy to forget a semicolon or mess up the syntax – and to end up with SQL Server that is not... (more)
category: Data | clicked: 8 | 2 comments | | source: beyondrelational.com
tags: SQL Server, TSQL, sql server 2012
8
Shouts
spam Shout it Mute it

Getting started with SQL Azure - Part 9: Developing SQL Azure applications
published 513 days, 7 hours, 34 minutes ago posted by dharadhara 517 days, 6 hours, 11 minutes ago
Tuesday, December 27, 2011 9:06:15 AM GMT Friday, December 23, 2011 10:28:43 AM GMT
Aim of “Getting started with SQL Azure” series is to offer you a set of brief articles that could act as a Launchpad for your to-be wonderful journey of exploring Microsoft’s cloud based database solution i.e. SQL Azure. First summary of previous blog... (more)
category: Data | clicked: 7 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, SQL Azure
8
Shouts
spam Shout it Mute it

Day 5: Generate Identity Column in PostgreSQL by using Serial Datatype
published 514 days, 8 hours, 25 minutes ago posted by dharadhara 517 days, 6 hours, 12 minutes ago
Monday, December 26, 2011 8:15:27 AM GMT Friday, December 23, 2011 10:28:16 AM GMT
In PostgreSQL we can use the Serial datatype for generating the identity column CREATE TABLE tblIndentity ( EmpID Serial NOT NULL, EmpName Character Varying(20) ); NOTICE: CREATE TABLE will create implicit sequence "tblindentityempidseq" for... (more)
category: Data | clicked: 15 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
10
Shouts
spam Shout it Mute it

Fun in TSQL - TSQL from TSQL
published 515 days, 20 hours, 14 minutes ago posted by kinj312kinj312 518 days, 6 hours, 49 minutes ago
Saturday, December 24, 2011 8:26:37 PM GMT Thursday, December 22, 2011 9:51:03 AM GMT
This is just for Fun. The following code is unformatted, unclear and may be confusing. But curious to know the result? Set the result mode of the query window to Text . While you are in Query Window press CONTROL+T and run the following code and see what... (more)
category: Data | clicked: 9 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
8
Shouts
spam Shout it Mute it

SQL Server 2012: Detecting Sort Warnings with Extended Events (sort_warning event)
published 515 days, 20 hours, 14 minutes ago posted by kinj312kinj312 518 days, 6 hours, 49 minutes ago
Saturday, December 24, 2011 8:26:37 PM GMT Thursday, December 22, 2011 9:50:45 AM GMT
Sort warnings events will rise when sort operation is performed in a query and it doesn’t fit into memory. In this case, SQL Server needs to spill the sort operation into tempdb which can result in a very slow physical operation especially if multiple... (more)
category: Data | clicked: 4 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

Getting Started with SSRS - Part 10 - Creating a Report with Charts
published 515 days, 20 hours, 14 minutes ago posted by kinj312kinj312 518 days, 6 hours, 50 minutes ago
Saturday, December 24, 2011 8:26:37 PM GMT Thursday, December 22, 2011 9:50:18 AM GMT
In this article, we will cover how to use Charts and Gauges with the reports in the SQL Server Reporting Services. In our earlier articles, we saw how to design and deploy basic reports and some options to administer the server with basic operations on manipulations with the folder. (more)
category: Data | clicked: 4 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, BI, SSRS
9
Shouts
spam Shout it Mute it

SQL Server 2012 Developer Training Kit
published 518 days, 16 hours, 35 minutes ago posted by kinj312kinj312 519 days, 6 hours, 59 minutes ago
Thursday, December 22, 2011 12:05:29 AM GMT Wednesday, December 21, 2011 9:41:25 AM GMT
The SQL Server 2012 Developer Training Kit has been updated with a bunch of new content (download it here ). This update includes eleven new hands-on labs covering Integration Services, the Semantic Model and Power View. Roger Doherty posted a complete... (more)
category: Data | clicked: 25 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, sql server 2012
8
Shouts
spam Shout it Mute it

Day 4: Find the Version of PostgreSQL
published 518 days, 16 hours, 35 minutes ago posted by kinj312kinj312 519 days, 6 hours, 59 minutes ago
Thursday, December 22, 2011 12:05:29 AM GMT Wednesday, December 21, 2011 9:40:53 AM GMT
We can get the version information in PostgreSQL by using the version function as shown under select version(); /* Result */ version ------- "PostgreSQL 9.1.0, compiled by Visual C++ build 1500, 32-bit" In Sql Server we use @@Version Hope this... (more)
category: Data | clicked: 6 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
10
Shouts
spam Shout it Mute it

SQL Server – TempDB v/s Model database – Minimum size considerations – CREATE DATABASE - Error Msg 1803
published 514 days, 8 hours, 25 minutes ago posted by kinj312kinj312 519 days, 7 hours ago
Monday, December 26, 2011 8:15:27 AM GMT Wednesday, December 21, 2011 9:40:33 AM GMT
A few weeks ago, I wrote a post related to the tempdb where I attempted to answer the question – Is TempDB a copy of the model database? The post attracted a couple of follow-up comments (which I really appreciate, because it gives everyone a great deal... (more)
category: Data | clicked: 32 | 3 comments | | source: beyondrelational.com
tags: SQL Server, TSQL, Database
7
Shouts
spam Shout it Mute it

Day 3: Overlay function in PostgreSQL
published 518 days, 16 hours, 35 minutes ago posted by dharadhara 520 days, 3 hours, 20 minutes ago
Thursday, December 22, 2011 12:05:29 AM GMT Tuesday, December 20, 2011 1:20:10 PM GMT
Purpose: To replace substring from a specified position to a specified position. Syntax: Overlay(string placing string from int [for int]) Example Select Overlay('www.beyondnational.com' Placing 'relational' From 11 For 8) "Overlay... (more)
category: Data | clicked: 4 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
8
Shouts
spam Shout it Mute it

Automated Trigger To Require a WHERE Clause
published 518 days, 16 hours, 35 minutes ago posted by dharadhara 520 days, 3 hours, 31 minutes ago
Thursday, December 22, 2011 12:05:29 AM GMT Tuesday, December 20, 2011 1:09:30 PM GMT
The Problem I was working on an ERP project for an electrical company. As a DBA my main task was to maintain database security and data consistency. A database developer was appointed on the client side to maintain the database. By mistake the developer... (more)
category: Data | clicked: 10 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
Previous 1 2 3 4 5 6 7 8 9 10 ... 28 29 Next