4,466 reputation
1548
bio website swasheck.wordpress.com
location The Wild, Wild West
age
visits member for 2 years, 8 months
seen 4 hours ago

Most days I feel like I'm in over my head.

Some days I actually am.

But every day, I feel like MacGyver.

... 99% of the time I name my table expressions agg


1d
awarded  Pundit
Jul
22
comment How do I include nulls during comparisons in SQL Server?
"Having to add parentheses and check if is null for every single field every single time I want to include it? Seems ugly, not intuitive and crazy." Bro! Do you even algebra?
Jul
15
comment Where Can I find *Current* PostgreSQL advice for a SQL Server DBA?
dba.stackexchange.com is a great place to start
Jul
15
reviewed Approve suggested edit on Using prepared statements in libpqxx with variable numbers arguments
Jul
14
awarded  Nice Question
Jul
14
comment How can I interpret the results of these DMVs to help me evaluate our partitioning strategy?
Thanks Brent. I appreciate the additional perspective.
Jul
12
comment Partitioning MySQL vs PostgreSQL
lines? lines of code? or do you mean rows? why are you doing it this way? are you considering OLAP, or OLTP as your system model? it's hard for me to tell.
Jul
9
awarded  Good Question
Jul
3
comment Is DBCC SHOWFILESTATS an accurate way to see unused space?
@Ek0nomik sure ... pop on into the heap to discuss
Jul
3
comment Is DBCC SHOWFILESTATS an accurate way to see unused space?
this is almost exactly the answer i was going to post - thanks. @Ek0nomik, if you want help tearing down partitioning, let us know.
Jul
3
comment Is select * still a big no-no on SQL Server 2012?
I still prefer SELECT 1 because it most obviously notifies future code maintainers of your intent. It's not a requirement, but if I see ... WHERE EXISTS (SELECT 1 ...) it pretty obviously announces itself as a truth test.
Jul
3
comment Is DBCC SHOWFILESTATS an accurate way to see unused space?
Quick math tells me that you have ~28GB free on your largest filegroup (and I'm just eyeballing and saying that you have ~60GB total unused disk space). There are many issues here: 1) partitioning isn't being properly used so there may be a better solution than "shrink a file", but we'd need to know your schema, 2) I'm concerned about the location of the files (all on the same disk/mountpoint), 3) even if you do shrink all of the files, how are you planning on "reclaiming" this space?
Jul
2
awarded  Inquisitive
Jul
2
awarded  Curious
Jun
27
reviewed Approve suggested edit on Error attaching mdf file to SQL Server 2008 R2
Jun
27
comment Error attaching mdf file to SQL Server 2008 R2
possible duplicate of Cannot access any database in SQL Server 2008 R2 Express after moving workstation from domain to workgroup
Jun
27
comment Alternatives to joins using Linked Server and OPENQUERY
What permissions does the linked sever user have on the remote server?
Jun
26
reviewed Close Understanding execution plans using TVPs
Jun
26
reviewed Close SQL Server Authentication vs Windows Authentication
Jun
26
comment How do you think in NoSQL?
@Zane indeed. it takes a while for the hipsters to catch up