4,579 reputation
11038
bio website billfellows.blogspot.com
location Kansas City, MO
age 39
visits member for 2 years, 10 months
seen 18 hours ago

Developer, devourer of pie, disciple of databases, dictator of datum, drinker of tea, delirious with alliterative devices

@billinkc


Jan
25
revised What is the most efficient way to update a product table with 1 million rows in MySQL
edited title
Jan
23
comment Copying Data to Other Database Tables
How would I asynchronously call 2 stored procs?
Jan
21
comment 1 time shrink of abused databse or restore from backup
The compressed backup will expand back to your 120GB uncompressed size.
Jan
17
comment SQL Server Physical Vs Virtual?
1. everything 2. It depends 3. It depends
Jan
16
comment ssis convert ddmonyyyy dd/mm/yyyy
How many rows do you expect to need to do this conversion upon?
Jan
15
comment Is there a quick way to find all columns in SQL Server 2008 R2 that are encrypted/have encrypted data?
We are lazy here and have computed columns that use autodecryptbyvoodoo. If you something similar, then you could look at column definitions for that
Jan
15
comment Is there a quick way to find all columns in SQL Server 2008 R2 that are encrypted/have encrypted data?
Assuming you're using a route like this msdn talks about, you know the data is encrypted but SQL Server only sees it as varbinary(n). Am I missing something?
Jan
14
comment Can an SSIS variable have a default value?
Your packages have a Variable which, is used to derive date strings and is based on GetDate. The desire is to allow this to be a user defined value in testing but default back to current date for production? How exactly do you assign the value? Do you use an Expression on the Variable or do you use a Script Task to assign the value. Do you really need GetDate or will the start of the package suffice as a point in time reference?
Jan
13
revised 24x7 vs Night Time Window
formatting before close
Jan
10
reviewed Approve suggested edit on MySql Server can't start after loss of power on windows
Jan
9
awarded  Pundit
Jan
7
comment Should I align my SQL Server file and growth sizes with the block sizes on my SAN?
I assume this is relevant to your interests sqlskills.com/blogs/paul/…
Jan
6
comment Is there a complete list of Online operations for each SQL Server version?
If no authoritative source is found, it would be helpful to future readers to list what you do know is an online operation from your time at MS.
Jan
5
reviewed Reject suggested edit on Select every n-th row, don't pull the entire table
Jan
3
revised SQL Server grouping and merging rows in new columns
Formatting
Dec
30
revised SQL server agent job built on SSIS package not working
formatting
Dec
20
comment Data Flow Task Produces No Rows with Declare Statement
I'd give you flack over the ` CAST(BaseDate AS DATE)` personally...
Dec
19
comment How can I change the number of @schedule_uid=N'????' to re-create a SQL Server Agent Job?
Yes, you need to copy/export the packages from the old server to the new server (or you must modify your job to reference the packages on the old server)
Dec
19
comment How can I change the number of @schedule_uid=N'????' to re-create a SQL Server Agent Job?
That "number" is the related schedule. You need to create one with the same interval if it does not exist or reuse the existing
Dec
19
comment SSIS internal caching - custom Task
Your code isn't exactly helpful but I will state that SSIS can spew 10k rows without batting an eye. I regularly pull data orders of magnitude larger than that. The likely culprit is your code itself. Without seeing what you're doing, we can't be of help. And if it gets into actual .NET, they may punt it over to SO. Either way, I'll look at your code