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

10h
comment Tools to visualize adhoc multi dimentional data
Right.. but SSRS doesnt support ad hoc queries, dont know about tableau , my point was, since SSAS allows me to specify a pages axis (as an example), is there a tool that will show the output in a way that the pages axis actually appears on different pages? But one where I write ad hoc queries and dont actually design reports
20h
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
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
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
Feb
25
comment Check if query will cause duplicate row
@MartinSmith Interesting.. didnt realize you could do that :)
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
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
comment Check if query will cause duplicate row
@Dmandy, whats your final objective? The above query will identify which all rows will cause a duplicate, what do you wish to accomplish next?
Feb
25
comment Inserting values into a column when Table1 column A value matches Table 2 Column B Value
You seem to want to do an update, not insert
Feb
25
comment Inserting values into a column when Table1 column A value matches Table 2 Column B Value
Can you post the schema of PurchaseInfo as well?
Feb
2
comment Can I fail the current transaction from within a trigger?
Just tried on your suggestion and it works :)
Dec
1
comment SQL Server job - powershell Where does “log to table” save logs
Thanks, I dont have help configured correctly I think, pressing F1 leads to help about the help viewer :)
Sep
7
comment Undo SQL UPDATE Azure DB
@kin ah.. that info was added later. I'll still let this be here if anyone using the new editions stumbles on this question...
Aug
15
comment Why is my filtered index being ignored?
@AaronBertrand I went through the 1st link just now, but the situation described there is virtually the same as mine, (except that IS NULL is used in the blog, but IS NOT NULL is used in my query. However, thats the situation for both the index and query) The optimizer did use the filtered index in the blog. In my case it does not (except when the filtered index is the only one)
Aug
8
comment Should I check for existence of temp tables in Stored Procedures?
Exactly what I was looking for, esp the code segments! I'll read through the links and post a separate question if I have specific doubts
Aug
8
comment Should I check for existence of temp tables in Stored Procedures?
@AaronBertrand What sort of code will cause an error where the SP fails, but the tables persist? I tried a trivial procedure and it doesnt exhibit this behaviour (call with 1, then 0 (which fails after creating the temp table due to a divide by 0), then 1 as parameters from the same SSMS query window) pastebin.com/yW7D4SgJ
Aug
8
comment Should I check for existence of temp tables in Stored Procedures?
Got it.. any examples of what sort of issues could creep up?
Mar
10
comment db INDEX on ORDER BY FIELD in very simple query does not help - still slow response?
I dont know anything about db2, but assuming it is similar to SQL Server, did you try a clustered index instead of a non clustered index (since you are using a select * query)?