151 reputation
7
bio website None
location London, Brighton, UK
age
visits member for 2 years, 11 months
seen Oct 22 at 10:22

Mainly a SQL Developer, but also develop using:

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


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
Apr
2
accepted Upper or Lower Case Optimisation on MS SQL Server
Mar
31
comment Upper or Lower Case Optimisation on MS SQL Server
And when the 2 days that remain for me to accept the answer expire, I will.
Mar
30
awarded  Supporter
Mar
30
comment Upper or Lower Case Optimisation on MS SQL Server
Apparently you can do it, and as other people have pointed out this is an install option do do with collation. My idea was to improve the performace of some queries, but apparently having a case sensative collation can cause problems, if you say miss a capital letter, the query will perform much worse than if you simply opted for a case insensative collation. But thanks again all.