Reputation
383
Top tag
Next privilege 500 Rep.
Access review queues
Badges
1 16
Impact
~5k people reached

9h
comment Tools to visualize adhoc multi dimentional data
Yes, that is a valid workaround, but instead of dumping the data to a single tabular result, I wanted to be able to explore the dimensions, like have each model name on a separate page with the category wise results on the page
2d
asked Tools to visualize adhoc multi dimentional data
May
11
awarded  Popular Question
May
7
asked Number of SQL Server languages
Mar
28
comment Is it possible to deploy Microsoft PDW on Azure?
@AaronBertrand oh.. so there is no way to actually install APS? You need to purchase an appliance only?
Mar
28
asked Is it possible to deploy Microsoft PDW on Azure?
Mar
26
asked Deploying SSRS reports on an “Air Gapped” report server without SSDT?
Mar
20
comment Is it possible to execute queries in random order?
@Muis So, let me get this straight, you have queries coming from different machines, with out of sync clocks , and you need to figure out a way to get them in the correct order somehow?
Mar
19
comment placing conditions in a join query join on vs where
Try them out and check the query plan. AFAIK SQL Server treats both as the same
Mar
19
answered Cannot open database “RidaDatabase” requested by the login. The login failed. Login failed for user 'PLESK01\IWAM_plesk(default)'
Mar
19
answered Is it possible to execute queries in random order?
Mar
19
answered Should my application utilize database credentials for user login?
Feb
26
awarded  Critic
Feb
25
comment Check if query will cause duplicate row
@MartinSmith Interesting.. didnt realize you could do that :)
Feb
25
revised Check if query will cause duplicate row
deleted 21 characters in body
Feb
25
comment Inserting values into a column when Table1 column A value matches Table 2 Column B Value
Yup.. looks like you need to do an UPDATE and not an INSERT here... You basically want to populate the SupplierContactName in the PurchaseInfo table where the SupplierName is present in the PurchaseInfo table right? Take a look at the statement in my answer
Feb
25
comment Check if query will cause duplicate row
Try example 2...
Feb
25
revised Check if query will cause duplicate row
added 224 characters in body
Feb
25
comment Check if query will cause duplicate row
So if you have 4 rows 'David',1 ' David',2 'David ',3 and ' David ',4 , you want to delete all 4?
Feb
25
revised Inserting values into a column when Table1 column A value matches Table 2 Column B Value
Formatting fix