4,409 reputation
11536
bio website DBADepot.com
location Ottawa, Canada
age 95
visits member for 3 years, 9 months
seen 6 hours ago

I am a SQL Server DBA in Ottawa Canada.

I am the founding partner of DBA Depot and the president of Metropolis Dreamware and Cooking With SQL. We provide database consultants to various public and private sector organizations.

I am a technical editor for SQL Server Magazine and the author of the T-SQL 101 series of articles / e-book.

I have been a SQL Server DBA since the bad old days of SQL 4.2.


Mar
8
asked Do you know an easy way to generate one record for each hour of the past 12 hours?
Mar
5
answered Find old linked servers on a restored copy of master/msdb db
Mar
2
answered Get failed SQL Server agent job?
Mar
2
comment Storing massive amounts of data from a sensor array
@JNK, thanks. Totally mis-read that. THen you are looking at 22GB per day. Not massive, but still quite a lot to manage.
Mar
1
comment Storing massive amounts of data from a sensor array
100,000 sensors X 10 samples per second X 28Bytes per sample x 24 hours per day = 2.2TB per day. That is a lot to put into two tables.
Mar
1
comment Storing massive amounts of data from a sensor array
What do you plan to do with this data, once it is in the database? I can't imagine being able to aggregate sensor data in a binary format, at least not easily or quickly at those levels.
Feb
28
answered How do I determine why my stored procedure is getting deadlocked?
Feb
27
comment How do I restore a SQL backup, while excluding a specific table?
putty and bash eliminate SQL Server as a possible suspect.
Feb
27
comment Speed up INSERTs
You can, but you are going to possibly waste time trying to overcome bottlenecks introduced by the laptop itself. It is like an olympic runner asking people to comment on his form, asking for ways to improve his time on the track, all the while he is wearing scuba gear.
Feb
27
comment Speed up INSERTs
The problem with your approach is that laptops and servers are fundamentally different from an internal architecture point of view.
Feb
25
answered Speed up INSERTs
Feb
23
comment What is the best approach to parsing a large amount of strings?
This definitely a one time request. My current projection is that the solution I went with will take about 2 hours.
Feb
23
revised What is the best approach to parsing a large amount of strings?
Included the details of the solution
Feb
23
comment What is the best approach to parsing a large amount of strings?
I altered the table and added two computed columns. One for first name, one for last name. Worked like a charm. I just processed the first 1,000,000 names in 9 seconds. That is the kind of speed I was looking for.
Feb
23
comment What is the best approach to parsing a large amount of strings?
That is a very well thought out answer, however when dealing with data volumes at this level, I know a set approach has to be taken. Looping 400,000,000 times will take hours and hours and hours.
Feb
23
accepted What is the best approach to parsing a large amount of strings?
Feb
23
comment What is the best approach to parsing a large amount of strings?
SQL Server 2008 R2
Feb
22
comment What is the best approach to parsing a large amount of strings?
The distinct result (last name) will be stored in another table for further analysis. The fun part is trying not to blow away the transaction log. I of course have limited space on this machine.
Feb
22
comment What is the best approach to parsing a large amount of strings?
The database is in simple mode, but I worry that adding the computed columns would be performed inside a transaction. I have been a DBA for many years, but suprisingly have not had much experience with computed columns.
Feb
22
asked What is the best approach to parsing a large amount of strings?