Browse by Tags

Scream if you want to go faster

My session for 24hrs of pass on High Performance functions will be starting at 11:00 GMT thats migdnight for folks in the UK. To attend follow this link https://www.livemeeting.com/cc/8000181573/join?id=N5Q8S7&role=attend&pw=d2%28_KmN3r The rest of the sessions can be found here http://www.sqlpass...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, May 19 2010
Enabling super single user mode with SQL Server

I recently got an email from a fellow MVP about single user mode. It made me think about some features I had just been looking at and so I started playing. The annoyance about single user mode for SQL Server is that its not really single user, but more like single connection mode. So how can you get...

Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Mar 26 2010
Have you really fixed that problem?

The day before yesterday I saw our main live server's CPU go up to constantly 100% with just the occasional short drop to a lower level. The exact opposite of what you'd want to see. We're log shipping every 15 minutes and part of that involves calling WinRAR to compress the log backups before...

Posted to DavidWimbush (Weblog) by DavidWimbush on Thu, Mar 18 2010
SSIS - XML Source Script

The XML Source in SSIS is great if you have a 1 to 1 mapping between entity and table. You can do more complex mapping but it becomes very messy and won't perform. What other options do you have? The challenge with XML processing is to not need a huge amount of memory. I remember using the early...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Mar 11 2010
XML Validation in SQL Server Intergration Services

I've been workig with XML in SQL Server Integration services this week and to say the XML task in SQL Server Integration services sucks is an understatement. Its buggy, the documentation is woefully inadequate in some cases wrong. I believe this was one of the first components written back for SQL...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Jan 20 2010
User defined function performance is awful, Micorosft please sort this out

User defined functions looked like something great when they were introduced in SQL 2005. They are a very logical step to make more code reuseable by wrapping common code in functions. It is an approach that is in development 101 and something everyone does and looks to doing. So what is the problem...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Jan 14 2010
Report Manager folder & file security

Just found the answer to something that has been irritating me slightly for ages: how to give a user access to a report without giving them access to all the other reports in the folder. We have folders that are based on the roles people perform in the company. We granted the appropriate domain groups...

Posted to DavidWimbush (Weblog) by DavidWimbush on Mon, Nov 2 2009
A significant part of sql server process memory has been paged out

Do you have the following occuring on your SQL Server system. If so it is likely you are running SQL Server 2005 or SQL Server 2008 Standard edition on x64 hardware. It will be causing you serious performance issues when it occurs, as all your database pages will be removed from memory and thus SQL will...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Mar 10 2009
Enforcing parent child relationship with Path Hierarchy model

With the classic adjacency model its dead easy to validate that a parent exists, its a bit more difficult with path model. The adjacency model you have a table with a self join you can easily add a foreign key between the two columns. When you store a path the difficulty is that you don't have anything...

Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Mar 9 2009
TSQL Scalar functions are evil.

I’ve been working with a number of clients recently who all have suffered at the hands of TSQL Scalar functions. Scalar functions were introduced in SQL 2000 as a means to wrap logic so we benefit from code reuse and simplify our queries. Who would be daft enough not to think this was a good idea. I...

Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Nov 3 2008

Page 1 of 8 (72 items) 1 2 3 4 5 Next > ... Last »