AdaTheDev

AdaTheDev
Name: AdaTheDev
Score: 393
Last Seen: 40 days, 10 hours, 43 minutes ago
Member Since: 27 February, 2010
SqlServerKudos
atom rss
1
kudos
spam Kudos Remove

The SQL Server MasterClass Experience | AdaTheDev
published 31 days, 6 hours, 52 minutes ago posted by AdaTheDevAdaTheDev 40 days, 10 hours, 43 minutes ago
Wednesday, June 30, 2010 1:06:43 PM GMT Monday, June 21, 2010 9:16:06 AM GMT
The SQL Server MasterClass Experience | AdaTheDev
SQL Server MasterClass 2010 was a very high quality, one day event presented by Paul S. Randal and Kimberly L. Tripp - not that they need any introduction of course. In fact if you don't know of them, then perhaps you should close down your SSMS window and switch off your machine - after reading my blog of course :). Maybe uninstall SQL Server too... The A-Team With two of the best SQL Server trainers in the industry offering a packed schedule of sessions, it was an... (more)
category: Community | clicked: 0 | comment | | source: www.adathedev.co.uk
tags: DBA, SQL, SQL Server, SQLServer
1
kudos
spam Kudos Remove

Optimising wildcard prefixed LIKE conditions | AdaTheDev
published 57 days, 8 hours, 49 minutes ago posted by AdaTheDevAdaTheDev 66 days, 11 hours, 44 minutes ago
Friday, June 04, 2010 11:09:34 AM GMT Wednesday, May 26, 2010 8:15:03 AM GMT
Optimising wildcard prefixed LIKE conditions | AdaTheDev
An overview on how to use indexed computed columns to optimise the performance wildcard prefixed LIKE conditions within an SQL query. (more)
category: Query | clicked: 2 | comment | | source: www.adathedev.co.uk
tags: Optimization, Performance, SQL, SQLServer
1
kudos
spam Kudos Remove

The SQLBits VI Experience | AdaTheDev
published 99 days, 11 hours, 58 minutes ago posted by AdaTheDevAdaTheDev 103 days, 12 hours, 35 minutes ago
Friday, April 23, 2010 8:00:45 AM GMT Monday, April 19, 2010 7:23:29 AM GMT
The SQLBits VI Experience | AdaTheDev
I had high expectations about SQLBits VI and it certainly lived up to it! Not only did it have great speakers, who really know their stuff and have an effortless way of getting the information across, but it was also free. So it goes without saying that it was a popular event. There were 4 sessions going on at any one time with a theme of performance and scalability and plenty of choice across DBA, Dev and BI areas. It did mean some tough decisions had to be made between which ones to attend! (more)
category: Community | clicked: 1 | comment | | source: www.adathedev.co.uk
tags: SQL Server, SQLBits
1
kudos
spam Kudos Remove

Rise of the SQL Server DevBA | AdaTheDev
published 138 days, 14 hours, 49 minutes ago posted by AdaTheDevAdaTheDev 148 days, 11 hours, 27 minutes ago
Monday, March 15, 2010 5:10:13 AM GMT Friday, March 05, 2010 8:31:57 AM GMT
Rise of the SQL Server DevBA | AdaTheDev
"DevBA" - an SQL Server Developer with a bit of DBA thrown in. As a developer, broadening your horizons to a DBA's mindset can offer great benefits and add to your skillset. (more)
category: Management | clicked: 3 | comment | | source: www.adathedev.co.uk
tags: DBA, Developer, SQLServer
1
kudos
spam Kudos Remove

Queue table processing in SQL Server | AdaTheDev
published 142 days, 14 hours, 2 minutes ago posted by AdaTheDevAdaTheDev 151 days, 11 hours, 10 minutes ago
Thursday, March 11, 2010 5:56:40 AM GMT Tuesday, March 02, 2010 8:49:00 AM GMT
Queue table processing in SQL Server | AdaTheDev
The scenario is you queue up records in a database table, each representing a piece of work needing to be done. You then want to have processes that periodically poll this table to pick up the next item of work from the queue and process them. (more)
category: Query | clicked: 2 | comment | | source: www.adathedev.co.uk
tags: SQL, SQLServer
1
kudos
spam Kudos Remove

Changing primary key index structure | AdaTheDev
published 144 days, 14 hours, 12 minutes ago posted by AdaTheDevAdaTheDev 152 days, 6 hours, 33 minutes ago
Tuesday, March 09, 2010 5:46:46 AM GMT Monday, March 01, 2010 1:25:24 PM GMT
Changing primary key index structure | AdaTheDev
Changing the structure of a primary key constraint index from nonclustered to clustered (or from clustered to nonclustered) is not necessarily as straight forward as it first seems. The process of changing it over, involves the constraint being dropped and then recreated. This could potentially cause a problem if you're making the change on a table whilst there could be activity against it. (more)
category: Management | clicked: 3 | comment | | source: www.adathedev.co.uk
tags: Indexes, SQL, SQLServer
1
kudos
spam Kudos Remove

Autogenerated SQL constraint names - why to avoid them | AdaTheDev
published 147 days, 14 hours, 27 minutes ago posted by AdaTheDevAdaTheDev 153 days, 20 hours, 58 minutes ago
Saturday, March 06, 2010 5:31:56 AM GMT Saturday, February 27, 2010 11:00:57 PM GMT
Autogenerated SQL constraint names - why to avoid them | AdaTheDev
Autogenerated constraint names in SQL Server - are they convenient, or are they a hindrance? For me, they are a hindrance. Why should I care that SQL Server autogenerates a constraint name when I don't explicitly specify one? Why does it matter if it names my PRIMARY KEY constraint "PKConstrai3214EC271FCDBCEB", or my DEFAULT constraint "DFConstraintColumnA__21B6055D"? This article explains reasons why you should specify a name yourself for each constraint. (more)
category: Management | clicked: 0 | comment | | source: www.adathedev.co.uk
tags: sqlserver database
1
kudos
spam Kudos Remove

SQL Server 2008 - Table Valued Parameters vs XML vs CSV | AdaTheDev
published 148 days, 14 hours, 28 minutes ago posted by AdaTheDevAdaTheDev 153 days, 21 hours, 1 minute ago
Friday, March 05, 2010 5:30:51 AM GMT Saturday, February 27, 2010 10:57:46 PM GMT
SQL Server 2008 - Table Valued Parameters vs XML vs CSV | AdaTheDev
A performance walkthrough of passing a dynamic number of values to an stored procedure using the new table valued parameter support within SQL Server 2008, in comparison with XML and CSV parameter approaches. (more)
category: Query | clicked: 2 | comment | | source: www.adathedev.co.uk
tags: database sqlserver table-valued-parameter