163 reputation
7
bio website None
location London, Brighton, UK
age
visits member for 3 years, 2 months
seen Feb 18 at 13:36

Mainly a SQL Developer, but also develop using:

C#, JavaScript, VB.NET, SSIS, SSRS, SSAS.


Feb
15
accepted Differntial back up: what happens to existing data?
Feb
14
revised Differntial back up: what happens to existing data?
added 560 characters in body
Feb
14
revised Differntial back up: what happens to existing data?
Additional explanation.
Feb
14
asked Differntial back up: what happens to existing data?
Oct
20
awarded  Popular Question
Sep
24
awarded  Autobiographer
Sep
5
asked Shrink SQL Server DB By xgb
Apr
4
awarded  Commentator
Apr
4
comment Import 10 Billion Rows, Daily
I increased the default buffer size by x10 in one of my tests, and while it helped, a bit, its still far too slow.
Apr
4
comment Import 10 Billion Rows, Daily
No worries. Local RAID 5, the file itself will (hopefully) be local, for testing its local. I have test boxes, but there is an element of urgency, an element. Not 100% my DBA would go for SQLIO. Might do, he's on holiday though. Thanks for the help.
Apr
4
comment Import 10 Billion Rows, Daily
Thanks, that's more useful. If I'm honest I'm not sure what you mean by "IO support"
Apr
4
comment Import 10 Billion Rows, Daily
@mustaccio fair comment. But I'm looking for help.
Apr
4
revised Import 10 Billion Rows, Daily
edited title
Apr
4
revised Import 10 Billion Rows, Daily
edited title
Apr
4
revised Import 10 Billion Rows, Daily
edited title
Apr
4
asked Import 10 Billion Rows, Daily
Apr
18
comment EXECUTE AS over Linked Servers
it does, its SA basically.
Apr
18
comment EXECUTE AS over Linked Servers
Cool, was looking at the right thing. It uses a specific context.
Apr
18
comment EXECUTE AS over Linked Servers
Sorry to sound naive, how would i go about doing that? Just to make sure we are on the same track.
Apr
18
asked EXECUTE AS over Linked Servers