10,068 reputation
22957
bio website
location Connecticut
age
visits member for 2 years, 11 months
seen 16 hours ago

I'm a dude.


2d
reviewed Reject suggested edit on Oracle client throwing ORA-12541: TNS:no listener
Apr
17
comment Advanced design question related to compound primary keys
@e4ch FYI you CAN do this with a CHECK constraint that calls a scalar UDF. It's not exactly a great design pattern but it's a possibility.
Apr
17
comment Avoiding entitized characters when using FOR XML PATH for string concatenation
String concatenation like this won't ever be pretty. Can't you do it in your app?
Apr
17
answered Advanced design question related to compound primary keys
Apr
17
comment Is it possible to get the queries executed in the past?
As written this is WAY too broad. Please feel free to edit it to make it much more specific: What RDBMS? What is your goal/purpose in trying to find "queries"?
Apr
16
comment A transport-level error has occurred when receiving results from the server. Semaphore timeout
Not sure to be honest, but it's a comm/networking issue between the client and server.
Apr
15
comment A transport-level error has occurred when receiving results from the server. Semaphore timeout
Well the xp_cmdshell is running on the SQL server I hope, but you are invoking it from SSMS on your local machine. I sounds like it's a networking issue between your local machine and the SQL Server.
Apr
14
answered Listing indexes and constraints
Apr
14
comment A transport-level error has occurred when receiving results from the server. Semaphore timeout
Actually I lied, this is apparently a networking issue in windows: support.microsoft.com/kb/325487
Apr
14
comment A transport-level error has occurred when receiving results from the server. Semaphore timeout
what's the command? Semaphore normally relates to CPU pressure.
Apr
14
comment Why do Indexed Views not permit non-unique clustered indexes?
A couple of comments: 1 - There's no reason you can't cluster on (GroupID, UserID). Don't limit yourself to a single column for the key. 2 - I imagine the limitation for a view is because this is a supplemental data object that needs to have rows easily tied to the NC indexes. For a table, the non-unique CI key gets an int appended to it, but I think that would be more challenging with an indexed view since it's not an actual table but needs to REFLECT an actual table.
Apr
10
comment Grouping Row Values Query
As it's currently written, this is a "black box" question. Unless you can give us some LOGIC behind your desired results, this doesn't really fit the purpose of this site. Please feel free to expand/clarify and flag this for reopening.
Apr
4
comment Import 10 Billion Rows, Daily
So, we need more info like: What is the source data? Where is the source data? How wide is the source data?
Apr
3
comment Database Design for NoSQL Fantasy Baseball League
I hate to burst your bubble but this is structured relational data, and would likely work a LOT better in a SQL database.
Apr
3
revised Logical optimization of joins and selections
added 244 characters in body
Mar
31
awarded  Nice Answer
Mar
27
revised Shutdown immediate displays an error
added 457 characters in body
Mar
24
comment Why has the backup time significantly increased?
Is this a real server or a VM? Is the storage specific to the server or shared? Are these full or incremental backups? Does it include TLog backups? Is the database in full or simple recovery mode? Are backups compressed?
Mar
24
comment Enhance performance of update query
Yeah this is a table scan, no way around it if the column isn't indexed.
Mar
19
comment Is this a race condition or bug in sql server using serializable TIL with updlock?
Important - what version of SQL Server is this? You tagged it 2008, can you give the full version number?