Warren P

331 reputation

bio	website	delphicodemonkey.blogspot.com
	location	Toronto, Canada
	age	43
visits	member for	10 months
	seen	Jan 30 at 20:49
stats	profile views	19

Software Developer (Professional), Amateur DBA.

Bits of code at Bitbucket hosting: https://bitbucket.org/wpostma

	331 reputation	bio	website	delphicodemonkey.blogspot.com	visits	member for	10 months
8 badges		location	Toronto, Canada		seen	Jan 30 at 20:49

summary answers questions tags badges favorites bounties reputation activity

62 Actions

suggestions reviews revisions comments badges posts accepts all

Jan 30	comment	SQL Server Create Access Denied even after adding MSSQLSERVER user permissions I have a feeling it has something to do with `OWNER RIGHTS`
Jan 30	asked	SQL Server Create Access Denied even after adding MSSQLSERVER user permissions
Jan 15	comment	How can I do a differential query (delta plus/minus) telling me what rows are in view A that are not in view B and vice versa? Oh... That covers either one being null, so either the left-hand-side (T1) or right-hand--side (T1) is null, but the other side is not null, and thus, we have a row returned. Both cases (t1 row missing, t2 row missing) are covered?
Jan 15	comment	How can I do a differential query (delta plus/minus) telling me what rows are in view A that are not in view B and vice versa? All fields are non-null.
Jan 15	asked	How can I do a differential query (delta plus/minus) telling me what rows are in view A that are not in view B and vice versa?
Dec 18	comment	How do I configure SQL Server 2012 so that it can restore and see files in my user account? If everybody changes their SQL Servers to run with a regular user ID when doing development, that might be the "best practice". I'm just wondering if that's a good idea or not. If manually adding "NT Service\MSSQLSERVER" to the folders I need to add to is the standard idea, I guess that would be the most logical minimal fix, right? Wot I wish is that the SQL server SSMS UI was a little easier to connect to this hidden "NT Server\xxx" account id.
Dec 18	asked	How do I configure SQL Server 2012 so that it can restore and see files in my user account?
Dec 17	revised	Is there a compact way to use a NOT IN (1,2,3) syntax when setting a variable? deleted 5 characters in body
Dec 17	comment	Is there a compact way to use a NOT IN (1,2,3) syntax when setting a variable? Wow. thanks for the IIF (2012+) idea. When we move to SQL 2012 that would be great. Otherwise CASE is at least more readable than my `if (a<>1)and(a<>2)...`. msdn.microsoft.com/en-us/library/hh213574.aspx
Dec 17	asked	Is there a compact way to use a NOT IN (1,2,3) syntax when setting a variable?
Dec 13	accepted	Is it possible to record incoming parameter values in a procedure call while tracing in SQL Server Profiler?
Dec 2	awarded	Nice Question
Dec 1	comment	Is it possible to record incoming parameter values in a procedure call while tracing in SQL Server Profiler? That's what I thought.
Dec 1	comment	Is it possible to record incoming parameter values in a procedure call while tracing in SQL Server Profiler? Well, it's the grain of sand in the oyster .... yadda yadda yadda... learning a bit more about how deep, how wide, how vast, and how interesting the depths of a database system are. I'm a developer who never knew that any of this stuff existed three months ago.
Nov 30	revised	Is it possible to record incoming parameter values in a procedure call while tracing in SQL Server Profiler? added 101 characters in body; edited title
Nov 30	asked	Is it possible to record incoming parameter values in a procedure call while tracing in SQL Server Profiler?
Nov 30	revised	Large set of execution plans hangs up SSMS added 253 characters in body
Nov 29	comment	Large set of execution plans hangs up SSMS It looks like the right approach is : Switch to profiling with SQL Profiler, then pick a subset that needs optimization and optmize 1 query, not a 10K-query-mega-mess. (I wish I could get rid of the mega-mess completely, but right now we need this mess.)
Nov 29	revised	Large set of execution plans hangs up SSMS added 275 characters in body; edited title
Nov 29	comment	Large set of execution plans hangs up SSMS That's a great idea. I would love it if SQL Sentry Plan Explorer could also implement enough "stored procedure debug" functionality to let me profile PART of a very complex tree of stored procedures + queries without modifying them all.