Question : We had a very strange encounter that all of our queries that uses an indexed column in the […]
Author: admin
How to take oracle 10g backup? [duplicate]
Question : This question already has an answer here: Closed 9 years ago. Possible Duplicate: How to take oracle 10g […]
Count total number of impression views and clicks for same ad id for diffrent ip
Question : I have a table like this: CREATE TABLE `ad_analytics` ( `id` int(90) NOT NULL, `ad_id` int(90) NOT NULL, […]
Why would shrinking TEMPDB log lead to slowness?
Question : I recently accidentally shrunk tempdb log to almost 0 after getting alerted that log drive filling up. I […]
Disabling variable substitution inside SQLCMD script when using :r syntax
Question : I am using SQLCMD to deploy a set of scripted Agent jobs. I am running these with a […]
Best way of order processing
Question : I would like to write a procedure for order processing Single Order can have multiple items, how can […]
Postgres: Are secondary indexes included in ACID?
Question : Are non-unique indexes / indices covered under the Consistency clause in aCid? (same for other attributes of an […]
Why does OBJECT_ID return NULL in a computed column?
Question : I’m trying to produce a usage report for some stored procedures in my database. The view view sys.dm_exec_procedure_stats […]
Get the last ID from Multiple Stored Procedures Executed
Question : So I have an XML file , to take data from it and insert into tables. For this […]
Mongodb 2.6 Server crash and not restarting
Question : We are using mongodb 2.6 with one Primary and 2 secondaries. One of the secondary has gone bad […]