SQL Server (RSS)


SQL Server 2005 UNPIVOT Command - changings columns to rows (normalizing)
16 June 08 03:55 PM | mab | 0 Comments   
Scenario A table that contains several columns that you need to take and change into rows in order to normalize the data. With SQL Server 2005, a new T-SQL command UNPIVOT can help. An example table: **Table called MyTable FieldID FieldOne FieldTwo FieldThree Read More...
Filed under:
How to write SQL to get a record to process in a cluster of processing computers
01 March 08 02:59 PM | mab | 1 Comments   
Working with a friend at work, we were discussing how to create some SQL to go after records in a table and process in a farm of computers (processing cluster). After few minutes of thinking I came up with the following. BEGIN TRAN MyTran UPDATE TOP 1 Read More...
Filed under:
How to backup and truncate all log files in a database
26 January 08 10:41 AM | mab | 3 Comments   
Some things to consider ... Make sure you can recover your server and database prior to issuing these commands. Since I am generically calling a rountine you will receive errors on the system databases. Your database and log files must follow the convention Read More...
Filed under:
Unable to delete or disable SQL Server job due to error regarding MSX server
26 January 08 09:54 AM | mab | 1 Comments   
Have you ever run across this error before when trying to delete or disable a SQL server job (or edit one): Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server . This sometimes can happen if you rename a Read More...
Filed under:
SQL Server 2005 SP2 - Access Denied on MSSQL\Data directory
22 October 07 03:50 PM | mab | 0 Comments   
This was a strange occurance I found recently. If you encounter the error SQL Server Setup failed to modify security permissions on file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\ you might want to look at the permissions on every file Read More...
Filed under:
Issue with SSIS Package calling stored procedure OUTPUT datetime parameter type
18 October 07 04:06 PM | mab | 1 Comments   
Symptom The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 3 ("@parameter"): Data type 0xE7 has an invalid data length or metadata length. Solution Installing SP2 my help. http://msdn2.microsoft.com/en-us/sql/bb426877.aspx Read More...
Filed under:
SQL Server 2005 Job, SSIS Step, Data Sources Access Denied
14 October 07 07:52 PM | mab | 1 Comments   
This particular issue was interesting. I was troubleshooting an issue where an individual had rights to run their SSIS Step in a SQL Job. They could also change variables being passed, add/remove steps in job, almost everything except modify the Data Read More...
Filed under:
Selecting the Most Current Record in a table (SQL2000 and 2005 examples)
19 September 07 07:45 PM | mab | 1 Comments   
My friend Alfredo helped with some SQL code and I thought it would be interesting to share. I was trying to select the most current record based on a unique id and a date within a single table. I was familar with the SQL 2000 way of doing things (a sub Read More...
Filed under:
Secure SSIS step execution when running as a SQL Job
23 July 07 05:12 PM | mab | 0 Comments   
Here is the scenario: SQL Agent account (NETWORK SERVICE or some DOMAIN ACCOUNT) does not have access to database activities in a SSIS package. You want to run a job but need to "proxy" a security account when a SSIS package runs. The following script Read More...
Filed under:
Programatic way to determine space used on all database tables
17 July 07 06:17 PM | mab | 2 Comments   
Here is one way I have found in order to get all tables space used. Effectively it queries the sp_tables and sp_spacedused in a loop to return the data. Declare @Table_Name varchar ( 255 ), @SQL varchar ( max ) --------------------------------------------------------------------------- Read More...
Filed under:
Login Failed for User '' - SQL Server
21 June 07 10:49 AM | mab | 0 Comments   
Periodically, I have seen issues with connecting to a remote SQL Server from SQL Server Management Studio, Asp.Net applications, ODBC connections, etc. Often times this is specific to a machine and not a complete on/off issue with SQL Server security. Read More...
Filed under:
Official: Visual Studio 2008 and SQL Server 2008
11 June 07 10:10 AM | mab | 0 Comments   
Well, I just got back from TechEd and WOW! lots of things happening. Along with the great sessions we officially announced the names of our next versions of Visual Studio and SQL Server ... Orcas = Visual Studio 2008, Team Foundation Server 2008 Katami Read More...
How to create a hyperlink in Reporting Services that opens in a new window
17 May 07 12:35 PM | mab | 3 Comments   
I was at a client and the question came up "Can I jump to another web based tool from my report?". The answer seemed obvious ... YES. What was not straightfoward was how to open the other web based tool in another window. Here is a solution a found (someone Read More...
SQL Server 2005 SP2 is now available
20 February 07 09:22 AM | mab | 0 Comments   
For those anxiously awaiting, SQL Server 2005 SP2 is now available at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx Read More...
Microsoft Visual Studio 2005 Team Edition for Database Professionals Resources
09 October 06 04:23 PM | mab | 0 Comments   
Although this is not the official list of resources, I had some questions from people asking where to find various bits for VSDB, so here is the most current I could find: Visual Studio 2005 Team Edition for Database Professionals (CTP 5 - Beta Published Read More...
More Posts Next page »
Page view tracker