DotNetShoutout - Stories tagged with TSQL

TSQL

atom rss
7
Shouts
spam Shout it Mute it

Getting Started with SSRS - Part 9 - Creating Matrix Report with inbuilt styles in SSRS
published 521 days, 12 hours, 51 minutes ago posted by dharadhara 522 days, 23 hours, 53 minutes ago
Thursday, December 22, 2011 12:05:29 AM GMT Tuesday, December 20, 2011 1:03:07 PM GMT
In this article we are going to see how to create a Matric Report with the help of the Report Wizard and Report Designer. In our earlier articles, we have covered how to design and deploy the report to the server with the option to design using the wizard and also with the report designer. However, in this article we are going to see how to make a matrix type report, since most of the business reports are developed based on the pivot format to analyze. (more)
category: Data | clicked: 7 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, BI, SSRS
8
Shouts
spam Shout it Mute it

Day 2: String aggregation in PostgreSQL
published 522 days, 17 hours, 24 minutes ago posted by kinj312kinj312 524 days, 1 hour, 55 minutes ago
Tuesday, December 20, 2011 7:32:32 PM GMT Monday, December 19, 2011 11:01:21 AM GMT
Aim: A query to show which employees works for which department Option 1: Using StringAgg function Purpose: This values helps to concatenate the input values into a string, separated by delimiter. We can pass any delimiter in this function Syntax: StringAgg... (more)
category: Data | clicked: 3 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
8
Shouts
spam Shout it Mute it

System Reserved Partition and monitoring
published 522 days, 17 hours, 24 minutes ago posted by kinj312kinj312 524 days, 2 hours, 10 minutes ago
Tuesday, December 20, 2011 7:32:32 PM GMT Monday, December 19, 2011 10:45:51 AM GMT
On Windows 2008 R2 , a System Reserved Partition is created. It is 100 MB and acts as a preparatory step for implementing Bitlocker. The installation doesn’t install Bitlocker. BitLocker is a disk encryption method for full disk encryption. The System... (more)
category: Data | clicked: 12 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, Database
8
Shouts
spam Shout it Mute it

SQL Server – Profiler – Part 6 – Correlating the Profiler Trace with Windows Performance Log Data
published 521 days, 12 hours, 51 minutes ago posted by kinj312kinj312 527 days, 5 hours, 1 minute ago
Thursday, December 22, 2011 12:05:29 AM GMT Friday, December 16, 2011 7:55:27 AM GMT
Based on popular demand from my colleagues and you, the kind reader, I am currently writing a series of posts on the SQL Server Profiler. Five parts have been published till date, and for your kind reference, here are the links to them: What is a SQL... (more)
category: Data | clicked: 6 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
8
Shouts
spam Shout it Mute it

Where did my RDL.DATA files go?
published 522 days, 17 hours, 24 minutes ago posted by kinj312kinj312 527 days, 5 hours, 1 minute ago
Tuesday, December 20, 2011 7:32:32 PM GMT Friday, December 16, 2011 7:55:06 AM GMT
Today morning, I was reading an old post on Clearing SSRS Query cache by Alex Whittles ( blog | twitter ). That is when I decided to try out something and opened up my most recent project to find some rdl.data files. Surprisingly, I did not find a single... (more)
category: Data | clicked: 3 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
8
Shouts
spam Shout it Mute it

SQL Server 2008 - Database Backup Compression, Amazing feature for DBA
published 522 days, 17 hours, 24 minutes ago posted by kinj312kinj312 527 days, 5 hours, 1 minute ago
Tuesday, December 20, 2011 7:32:32 PM GMT Friday, December 16, 2011 7:54:46 AM GMT
Production Database servers may have databases which are heavily in size. For the maintenance of those database backups are very hard and lengthy as the backups of those heavily databases take more tome to execute and very CPU, memory and IO consumptive... (more)
category: Data | clicked: 5 | comment | | source: beyondrelational.com
tags: SQL Server, DBA, TSQL
7
Shouts
spam Shout it Mute it

Multipart names and keyboard shortcuts
published 522 days, 17 hours, 24 minutes ago posted by dharadhara 528 days, 3 hours, 48 minutes ago
Tuesday, December 20, 2011 7:32:32 PM GMT Thursday, December 15, 2011 9:08:38 AM GMT
I had blogged about Different ways to know structure of the tables . One of the methods is to highlight the object name and press Alt+F1. But this will not work if the object name contains multiparts ie database name, owner name etc. Consider the following... (more)
category: Data | clicked: 6 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

DB2 Database code set
published 521 days, 12 hours, 51 minutes ago posted by dharadhara 528 days, 3 hours, 48 minutes ago
Thursday, December 22, 2011 12:05:29 AM GMT Thursday, December 15, 2011 9:08:19 AM GMT
The DB2 code set value defines the character encoding used by the database. Setting the appropriate value for translation, for example: Euro symbol and DB2 database codeset To get the DB2 database code set value, use: db2 get db cfg for MY_DB --From a... (more)
category: Data | clicked: 5 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, Database
7
Shouts
spam Shout it Mute it

Getting Started with SSRS - Part 8 -Show SSRS Report in ASP.NET Web Page
published 521 days, 12 hours, 51 minutes ago posted by dharadhara 528 days, 3 hours, 48 minutes ago
Thursday, December 22, 2011 12:05:29 AM GMT Thursday, December 15, 2011 9:07:49 AM GMT
In this article, we will cover how to use the deployed SSRS Report on to the ASP.NET Web application. In our earlier articles we have seen the steps to create and deploy the report to the Reporting Server and administer the deployed reports. In real time, we have seen requirements on accessing the reports from different clients. (more)
category: Data | clicked: 16 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, BI, SSRS
7
Shouts
spam Shout it Mute it

Study of WAITSTATS(Part 5) - ASYNC_NETWORK_IO
published 522 days, 17 hours, 24 minutes ago posted by kinj312kinj312 529 days, 3 hours, 39 minutes ago
Tuesday, December 20, 2011 7:32:32 PM GMT Wednesday, December 14, 2011 9:16:45 AM GMT
ASYNCNETWORKIO, as the name suggests it is a wait type associated with the network. Infact it deals with the network buffers. Does it mean it is completely a network issue? - Never, it might be a network issue or not. However we need to check our end... (more)
category: Data | clicked: 5 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
9
Shouts
spam Shout it Mute it

Day 76: PL/SQL - 14 (Writing Dynamic SQL Queries in PL/SQL using Native Dynamic SQL(NDS))
published 522 days, 17 hours, 24 minutes ago posted by dharadhara 530 days, 3 hours, 15 minutes ago
Tuesday, December 20, 2011 7:32:32 PM GMT Tuesday, December 13, 2011 9:41:34 AM GMT
Sign in | JoinHomeBlogsAskJust LearnedPostswhat.isnew.inPuzzlesToolsQuizModules (beta) Getting Started with SSRS - Part 6 : Creating Deleting and Moving a folder in SSRS Server First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login. niladri.biswasHomeRSS for PostsRecent Blog PostsDay 12: Math functions and operators in PostgreSQL...Day 11: Math functions and op... (more)
category: Data | clicked: 17 | 1 comment | | source: beyondrelational.com
tags: SQL Server, PL/SQl, TSQL
9
Shouts
spam Shout it Mute it

TSQL Challenge 70 - Find the longest sequence of alphabets in a string – Part 2
published 522 days, 17 hours, 24 minutes ago posted by dharadhara 530 days, 3 hours, 16 minutes ago
Tuesday, December 20, 2011 7:32:32 PM GMT Tuesday, December 13, 2011 9:40:04 AM GMT
This challenge invites you to identify the longest sequence of alphabets from a string. This challenge is Version 2 of the TSQL Challenge 67. The difference is that in this version, you should apply circling while finding the longest sequence. (more)
category: Data | clicked: 15 | comment | | source: beyondrelational.com
tags: SQL Server, tsql challenges, TSQL
9
Shouts
spam Shout it Mute it

Getting Started with SSRS - Part 7 - User Roles and Permissions in SSRS Server
published 522 days, 17 hours, 24 minutes ago posted by dharadhara 530 days, 3 hours, 17 minutes ago
Tuesday, December 20, 2011 7:32:32 PM GMT Tuesday, December 13, 2011 9:39:19 AM GMT
In this article, we will see how to set user access roles and permissions for a specified user in SQL Server Reporting Services. User permissions in SSRS server is a big challenge for accessing the server for specified users. In this article, we will see how to add a new user role and provide permissions for the user to access particular components of the server reports. (more)
category: Data | clicked: 13 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, SSRS
10
Shouts
spam Shout it Mute it

Day 75: PL/SQL - 13 (How to make custom Aggregate Function in Oracle)
published 529 days, 22 hours, 17 minutes ago posted by dharadhara 531 days, 4 hours, 38 minutes ago
Tuesday, December 13, 2011 2:39:39 PM GMT Monday, December 12, 2011 8:17:57 AM GMT
In this article, we will look into creating our own Aggregate Function in Oracle. User-defined aggregates are a feature of the Extensibility Framework.It is possbile to make user define Aggregate function because of Oracle's Data Cartridge model which... (more)
category: Data | clicked: 14 | comment | | source: beyondrelational.com
tags: SQL Server, PL/SQl, TSQL
13
Shouts
spam Shout it Mute it

SQL Server – Profiler – Part 5 – Replaying a trace – from a file or a table – using breakpoints during trace replay
published 521 days, 12 hours, 51 minutes ago posted by dharadhara 531 days, 4 hours, 40 minutes ago
Thursday, December 22, 2011 12:05:29 AM GMT Monday, December 12, 2011 8:15:59 AM GMT
Based on popular demand from my colleagues and you, the kind reader, I am currently writing a series of posts on the SQL Server Profiler. Four parts have been published till date, and for your kind reference, here are the links to them: What is a SQL... (more)
category: Data | clicked: 66 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
9
Shouts
spam Shout it Mute it

Day 74: ROW_NUMBER, RANK, DENSE_RANK, NTILE in Oracle
published 529 days, 22 hours, 17 minutes ago posted by kinj312kinj312 533 days, 4 hours, 20 minutes ago
Tuesday, December 13, 2011 2:39:39 PM GMT Saturday, December 10, 2011 8:36:13 AM GMT
RowNumber() - Assigns sequential numbers to the records of a result-set or to the records within groups of a result-set Rank() - Returns the rank of each row within the partition of a result set. DenseRank() - Returns the rank of rows within the partition... (more)
category: Data | clicked: 6 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, Oracle
7
Shouts
spam Shout it Mute it

A new feature of SQL Server Denali - Multi Monitor Support of SSMS
published 532 days, 44 minutes ago posted by dharadhara 534 days, 4 hours, 15 minutes ago
Sunday, December 11, 2011 12:12:15 PM GMT Friday, December 09, 2011 8:40:49 AM GMT
I have drafted all the new features and enhancements introduced by SQL Server denali CTP1 and CTP3 . Multi Monitor Support is the new feature among them. We can do with this feature : 1. Using this feature we can use multi screen of query analyzer or... (more)
category: Data | clicked: 36 | 1 comment | | source: beyondrelational.com
tags: SQL Server, ssms, TSQL
7
Shouts
spam Shout it Mute it

Adding a Target line to a Horizontal Bar Chart in SSRS
published 532 days, 44 minutes ago posted by dharadhara 534 days, 4 hours, 16 minutes ago
Sunday, December 11, 2011 12:12:15 PM GMT Friday, December 09, 2011 8:40:26 AM GMT
This is usually the time of the year when I get to my laziest best. The cold weather and the approaching holiday season brings out the sloth in me and I have a huge backlog of articles I need to read as well as tend to. But somehow I have pulled... (more)
category: Data | clicked: 20 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, SSRS
6
Shouts
spam Shout it Mute it

MS DTC and sys.dm_tran_active_transactions
published 532 days, 44 minutes ago posted by kinj312kinj312 535 days, 3 hours, 16 minutes ago
Sunday, December 11, 2011 12:12:15 PM GMT Thursday, December 08, 2011 9:40:28 AM GMT
A sql reindex command was being blocked by two active transactions in MS DTC. Use sys.dmtranactivetransactions to report more detail on transactions select * from sys.dmtranactivetransactions where transaction_uow = '922D5B60-A5CA-4C96-8891... (more)
category: Data | clicked: 5 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

Day 72: Synonym in Oracle
published 532 days, 44 minutes ago posted by kinj312kinj312 535 days, 3 hours, 16 minutes ago
Sunday, December 11, 2011 12:12:15 PM GMT Thursday, December 08, 2011 9:39:57 AM GMT
Purpose: It is an alternative name/alias assigned to the objects like views, sequences, stored procedures etc. Syntax Create [or Replace] [Public] Synonym [Schema .] SynonymName For [schema .] objectname [@ dblink]; It is an alias for the following... (more)
category: Data | clicked: 4 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, Oracle
Previous 1 2 3 4 5 6 7 8 9 10 ... 28 29 Next