Forum Replies Created
Viewing 15 posts - 3,721 through 3,735 (of 8,753 total)
-
RE: How do I get a multi user table created without DBA involved?
Lynn Pettis (4/15/2016)
And out of curiosity, why are you trying to back door the DBA? Not a good way to influence or make friends with a DBA.Further on Lynn's...
-
RE: Are the posted questions getting worse?
Steve Jones - SSC Editor (4/15/2016)
About to head off to SQL Saturday Phoenix. Anyone else going?Wouldn't mind to go even if it was only for the 20-30C
😎
BTW when you come...
-
RE: Are the posted questions getting worse?
jeff.mason (4/15/2016)
Eirikur Eiriksson (4/15/2016)
Phil Parkin (4/15/2016)
Anyone have a crystal ball, several hours to kill and feeling masochistic? Dive in!Quick fix in three steps
1. Drop procedure
2. Drop developer
3. Create developer
😎
Do 2...
-
RE: Are the posted questions getting worse?
Lynn Pettis (4/15/2016)
Phil Parkin (4/15/2016)
Anyone have a crystal ball, several hours to kill and feeling masochistic? Dive in!Need multiple crystal balls for this one.
IIRC, using the crystal ball on this...
-
RE: Are the posted questions getting worse?
Phil Parkin (4/15/2016)
Anyone have a crystal ball, several hours to kill and feeling masochistic? Dive in!Quick fix in three steps
1. Drop procedure
2. Drop developer
3. Create developer
😎
-
RE: Are the posted questions getting worse?
Chris M and a good chat
😎
-
RE: Who's going to SQL Bits in Liverpool?
In Cobenhagen, go for Grøn or Jacobsen or similar, Stærk Øl will knock one out after few:-D
😎
Will treat you a proper Ale if/when we finally meet
-
RE: Determining cost threshold for parallelism
TheSQLGuru (4/12/2016)
The default of 5 for cost threshold for parallelism is almost universally too low. I don't know of a formula for setting a higher value, but I know pretty... -
RE: find date value from file name
Quick thought, look at Ola Hallengren's maintenance scripts, he has a very good clean up process there
😎
-
RE: Who's going to SQL Bits in Liverpool?
Steve Jones - SSC Editor (4/12/2016)
I'll be there. Should arrive Thursday sometime.Would love to have a chat on version control and cloud implementations:-)
😎
-
RE: Who's going to SQL Bits in Liverpool?
Will miss the breakfast but will be in time for your talk, Query Store at 11:00?
😎
-
RE: Query Execution Plan, differs between environments
Quick question, are the environments identical and with the same settings (maxdop, maxmem etc.)?
Have you tried to run the query on dev with OPTION (RECOMPILE)?
😎
-
RE: SQL Oddity
GSquared (4/11/2016)
I just ran into this in a query. Can anyone come up with a good explanation for why anyone would do this?SELECT
ISNULL(MyTable.MyColumn, NULL)...
-
RE: Security - View is not able to select from base table
Are there any tables or views outside the Reporting schema directly or indirectly referenced in the query that's failing? The error message referred to one Stats schema.
😎
-
RE: Security - View is not able to select from base table
Quick questions, which objects in db CmsTestDB schema Stats are used? what are the permissions the user has? Are all references schema qualified? What is the user's default schema...
Viewing 15 posts - 3,721 through 3,735 (of 8,753 total)