Reputation
2,899
Top tag
Next privilege 3,000 Rep.
Cast close & reopen votes
Badges
3 14 46
Newest
 Caucus
Impact
~297k people reached

6h
awarded  Caucus
Jul
24
comment SQL server tools to identify query optimisations and missing indexes
+1 For Brent Ozar. I would highly recommend getting his free stored procs like sp_BlitzCache and sp_BlitzIndex (for example) as they help you wade through the DMVs and DMFs to find what you are looking for.
Jul
20
revised IBM DB2 9.7, possible to temporarily disable transaction logs?
Correction to one of my previous statements.
Jul
16
answered Create DB2 on networked drive but managing from Windows
Jul
15
awarded  Popular Question
Jul
8
answered How to resolve foreign key references across different databases (iSeries and SQL Server)
Jul
7
comment DB2 Trigger Error : An unexpected token “OR INSERT” was found following SQLCODE=-104, SQLSTATE=42601, DRIVER=3.68.61
@mustaccio. Since this is the answer, you should list it as such so John Corner can accept it.
Jul
1
revised What exactly is binding in DB2?
updated link.
Jul
1
answered Check if encrpytion key is valid in DB2
Jul
1
comment RAM utilization
I like to follow the formula I read from Jonathan Kehayias. 1 GB for OS, plus 1 GB for each 4GB for the first 16 GB, and then 1GB for each 8 GB after the first 16 GB). This is what should be reserved for the system. The rest can go to SQL Server if it is a dedicated system.
Jul
1
comment RAM utilization
SQL Server will normally grab a lot of memory. You should generally cap it around 80 - 90% of the systems memory. The system should have at least 4GB of memory comfortably. Or, if memory starved, perhaps 2 GB.
Jun
26
comment check when last backup was taken
In my case (I use Ola Hallengren's scripts), I can check the CommandLog table that those log to. I also get an email every day on success or failures (right now we only back up daily). And I also visit the server and check on the backups and logs, cpu, memory, etc. for a health spot check.
Jun
19
comment Identical query slower when searching for `T` rather than `F`
Brent Ozar's team explains how this happens and some of what you can do to mitigate this: brentozar.com/archive/2013/06/…
Jun
18
awarded  Revival
Jun
18
answered How do I modify a stored procedure in IBM DB2?
Jun
15
comment How to create a Linked Server from SQL Server 2008 to DB2?
Which OS is your DB2 on? Unix, Linux, or Windows? Because ODBC is generally bound by default (given which packages get bound by the admin when creating databases) on Unix and Linux, but must be explicitly bound by the admin on Windows. That might be part of your issue here.
Jun
10
answered DB2 10.5 - When inserting, the database is trying to reuse index keys on GENERATE ALWAYS
Jun
9
awarded  Popular Question
May
29
revised How to revoke DBADM and clean up any related objects from DB2 LUW
deleted 1 character in body
May
27
revised Which size is correct?
edited body