AdaTheDev

AdaTheDev
Name: AdaTheDev
Score: 563
Last Seen: 386 days, 13 hours, 6 minutes ago
Member Since: 27 February, 2010
SqlServerKudos
atom rss
1
kudos
spam Kudos Remove

GROUPING SETS in SQL Server | AdaTheDev
published 376 days, 23 hours, 43 minutes ago posted by AdaTheDevAdaTheDev 386 days, 13 hours, 6 minutes ago
Monday, January 24, 2011 4:42:57 AM GMT Friday, January 14, 2011 3:20:19 PM GMT
GROUPING SETS in SQL Server | AdaTheDev
Something I personally haven't seen a lot of out there in the SQL Server world, is use of GROUPING SETS - an operator that can be applied in a GROUP BY clause. So what does it do? How would you use it? (more)
category: Query | clicked: 0 | comment | | source: www.adathedev.co.uk
tags: grouping sets, SQL
1
kudos
spam Kudos Remove

SqlBulkCopy to SQL Server in Parallel | AdaTheDev
published 376 days, 23 hours, 43 minutes ago posted by AdaTheDevAdaTheDev 386 days, 13 hours, 7 minutes ago
Monday, January 24, 2011 4:42:57 AM GMT Friday, January 14, 2011 3:19:30 PM GMT
SqlBulkCopy to SQL Server in Parallel | AdaTheDev
In an earlier post last year, I blogged about high performance bulk loading to SQL Server from .NET using SqlBulkCopy. That post highlighted the performance gain that SqlBulkCopy gives over another batched insert approach using an SqlDataAdapter. But is it possible to squeeze more performance out? Oh yes.... (more)
category: Analysis | clicked: 2 | comment | | source: www.adathedev.co.uk
tags: .NET, bulk insert, sqlbulkcopy
1
kudos
spam Kudos Remove

Passing a TABLE variable into dynamic SQL | AdaTheDev
published 533 days, 11 hours, 37 minutes ago posted by AdaTheDevAdaTheDev 542 days, 21 hours, 6 minutes ago
Friday, August 20, 2010 4:48:58 PM GMT Wednesday, August 11, 2010 7:19:46 AM GMT
Passing a TABLE variable into dynamic SQL | AdaTheDev
A question popped up on StackOverflow today, asking how to pass a TABLE variable into a dynamic SQL statement in SQL Server 2008. I've previously blogged about table-valued parameters, comparing the approach of passing in a TABLE of values to a stored procedure to the techniques you'd have had to use in earlier versions of SQL Server (e.g. CSV or XML), but this specific question is worth a quick follow-up. (more)
category: Query | clicked: 1 | comment | | source: www.adathedev.co.uk
tags: SQL, SQL Server
1
kudos
spam Kudos Remove

The SQL Server MasterClass Experience | AdaTheDev
published 584 days, 15 hours, 20 minutes ago posted by AdaTheDevAdaTheDev 593 days, 19 hours, 10 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 610 days, 17 hours, 17 minutes ago posted by AdaTheDevAdaTheDev 619 days, 20 hours, 11 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 652 days, 20 hours, 25 minutes ago posted by AdaTheDevAdaTheDev 656 days, 21 hours, 3 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 691 days, 23 hours, 16 minutes ago posted by AdaTheDevAdaTheDev 701 days, 19 hours, 54 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 695 days, 22 hours, 30 minutes ago posted by AdaTheDevAdaTheDev 704 days, 19 hours, 37 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: 3 | comment | | source: www.adathedev.co.uk
tags: SQL, SQLServer
1
kudos
spam Kudos Remove

Changing primary key index structure | AdaTheDev
published 697 days, 22 hours, 39 minutes ago posted by AdaTheDevAdaTheDev 705 days, 15 hours, 1 minute 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 700 days, 22 hours, 54 minutes ago posted by AdaTheDevAdaTheDev 707 days, 5 hours, 25 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: 1 | 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 701 days, 22 hours, 55 minutes ago posted by AdaTheDevAdaTheDev 707 days, 5 hours, 28 minutes 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: 14 | comment | | source: www.adathedev.co.uk
tags: database sqlserver table-valued-parameter