Beyondrelational - beyondrelational.com - beyondrelational.com
General Information:
Latest News:
Money datatype and formatted values 29 Apr 2013 | 05:00 am
Money is one of the datatypes in SQL Server and it can be used to store monetary values. It will not only accept integer and decimal values but formatted values too. For example you can express values...
When exactly scheduled jobs started and completed - SQL Server 28 Apr 2013 | 05:00 am
Some days ago, i worked to get failed jobs detail and an alert for the same. I used some system tables from msdb database to fetch the details for same. And msdb.dbo.sysjobhistory is one of the table ...
The EXECUTE permission was denied on the object 'xp_sqlagent_enum_jobs', database 'mssqlsystemresource', schema 'sys' - SQL Server 9 Apr 2013 | 09:30 pm
Recently while working with one query to get schedule jobs status, i used xp_sqlagent_enum_jobs object which gives details of state values of all jobs in msdb database and this is undocumented object....
Moving table or indexes on another filegroup - SQL Server 4 Apr 2013 | 05:00 am
Because of data growth and performance issue we need to move tables or indexes to other filegroups. The purpose of moving tables or indexes to improve the database performance as it reduce I/O from si...
Conditional aggregation - SUM Vs COUNT 26 Mar 2013 | 04:00 am
You can do conditional aggregation like SUM(CASE WHEN .. THEN 1 ELSE 0 END),....etc to find a count for a particular match. This type of conditions are useful when you want to write a CROSS-TAB/PIVOT ...
Using FileTable in SQL Server 2012 23 Mar 2013 | 04:00 am
FileTable is a new concept in SQL Server 2012, using which you can store files and documents in special tables in SQL Server called FileTables, but access them from Windows applications as if they wer...
SQL Server : Part 6 : Design consideration of Clustered Index 22 Mar 2013 | 05:43 am
In our earlier post, we have discussed about the structure and storage of clustered index. In this post we will discuss about the design consideration of clustered index.There are couple of points tha...
MDX #28– Time functions will not work with subquery 22 Mar 2013 | 04:00 am
I had a post last month, MDX #25 – Slicer or Sub-Cube?, verifying that the query context did not change with the subquery. This can pose problems if you want to use the Time-series functions in MDX. ...
Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection.-SQL Server SSIS 21 Mar 2013 | 04:04 pm
This week, I resolved one issue which I received continuously which is noting but exactly displayed in post title. The issue occurred when I ran ssis package with batch file or scheduled job and sam...
Failed to acquire connection. Connection may not be configured correctly or you may not have the right permissions on this connection.-SQL Server SSIS 21 Mar 2013 | 04:04 pm
This week, I resolved one issue which I received continuously which is noting but exactly displayed in post title. The issue occurred when I ran ssis package with batch file or scheduled job and sam...
