2,672 reputation
1418
bio website alirazeghi.com
location Santa Monica
age 35
visits member for 2 years, 3 months
seen 20 hours ago

Lover of all things technology, history, classic art, politics (not mud slinging), with a specific fondness of databases and long walks on the beach :P


Dec
11
comment Select Query takes more than a minute to retrieve data
Any chance we can see the execution plan? :D
Dec
9
comment Did I Properly Diagnose That It's Not A SQL Server Issue?
Good point Thomas on the CSV, we were able to diagnose it was NOT a SQL Server issue but instead, the web server. +1 though.
Dec
9
comment Is it advisable to restart a SQL server box running Windows when disk space is low?
You can't just copy and paste SQL Server files like you can with MongoDB, why are you trying to 'copy/paste' them instead of backing them up over the network?
Dec
6
reviewed Approve Choosing shard key with compound index field
Dec
3
comment MongoDB store weekly data?
You might not need to aggregate the historic teams and keep that info in mongodb, you could also just do the aggregation in the app layer and avoid the consolidated document holding historic teams info. Instead of tags just use a group of arrays and that should be easier for backbone js to query IMO. Just a thought though, I'm sure there's lots of great ways to do this.
Dec
3
answered MongoDB store weekly data?
Dec
3
comment Did I Properly Diagnose That It's Not A SQL Server Issue?
ah i gotcha, thanks. These were gathered live during the issue. It seems like it wasn't a SQL Server issue now that the other temas got to investigate it.
Dec
3
comment Did I Properly Diagnose That It's Not A SQL Server Issue?
extended events on the query SPID to record query wait stats. Windows PerfMon for disk/cpu/memory, and queried the plan cache.
Dec
3
revised Did I Properly Diagnose That It's Not A SQL Server Issue?
added 431 characters in body
Dec
3
asked Did I Properly Diagnose That It's Not A SQL Server Issue?
Sep
22
comment “Restore With Replace” or drop/restore with Instant Initialization on?
good point on the db settings on a drop vs a non drop. +1.
Sep
21
awarded  Yearling
Sep
2
reviewed Approve Can a Couchbase application work with no network connection (like CouchDB)?
Jul
23
comment Why is my select statement so slow?
Can you paste the execution plan to pastebin or somewhere of the sort so we can see it?
Jul
18
comment SQL Server 2000 Named Instance cannot connect remotely
might be a compound issue. Can you check if you can connect to the server UDP Port 1434 and can you check if the server is listening to the port via netstat -an? Then check to make sure the firewall has that port enabled. Check service to ensure it's actually still on. If it is, check out this link from back in the day: sqlmag.com/sql-server/…. ALSO CHECK REVERSE DNS and also try to connect to the server via \\IP\instance.
Jul
18
reviewed Approve What permissions are necessary for truncating a table?
Jul
11
awarded  Famous Question
Jul
2
awarded  Curious
May
22
revised Can I use SQL Server Management Studio 2012 on a 2008 server?
added 139 characters in body
Apr
9
comment Can I use SQL Server Management Studio 2012 on a 2008 server?
Good point Kenneth, that's good to note!