Viewing 15 posts - 1 through 15 (of 15 total)
Actually, I want to recompile each time, b/c I want to test each instance of my code w/o it using a cached plan, to check for variances in generated query...
September 26, 2015 at 8:16 am
Hi, Kevin.
Thanks for your response.
By functions, I mean table-valued functions (NOT multi-statement table valued functions.) We have a very small number of scalar functions & a very small number...
March 18, 2015 at 9:42 pm
Could do that, prefer this approach.
May 7, 2014 at 11:04 am
CHECKIDENT(RESEED) is quirky, based on TRUNCATE/DELETE & whether the table is a brand-new (never-contained-any-rows) table or an already-existing table.
CHECKIDENT(RESEED,0) acts differently, based on the above. If it's a brand-new table,...
May 7, 2014 at 10:58 am
I think placing this in my test data script will resolve the issue (or rather, cover it, for both situations):
DECLARE @DELETEDFROM_<tablename> bit = 1
IF (SELECT IDENT_CURRENT('<tablename>') = 1 AND...
May 7, 2014 at 9:41 am
Running the above command, all 13 rows of settings are identical between the two servers.
I'm starting to think the issue is not in SQL Server but that somehow the Visual...
May 7, 2014 at 9:15 am
Recovery model for both is "Full". Not quite sure what you mean on the other setting.
May 7, 2014 at 8:12 am
Thanks. I installed the script you suggested, on both my PC & the network server. There were only three settings that were different, none of which seems relevant:
My PC =...
May 6, 2014 at 3:57 pm
My last statement begs additional investigation. The DELETE/TRUNCATEs wouldn't be necessary on a fresh build.
April 23, 2014 at 8:15 am
That's why it seems odd. In both cases, this behavior is observed after a fresh build, i.e., after the TFSBuild process first DROPS the database, then constructs it afresh. So,...
April 23, 2014 at 8:14 am
Isn't cliconfg just an alternate interface for SQL Server Configuration Manager, which I've been using? When I open cliconfg, I see all of the aliases I set up using SS...
December 11, 2013 at 7:42 am
I'm just following company standards. The typical way they've been setting up Visual Studio source-controlled projects, that have databases associated with them, is to create the database connections using aliases,...
December 11, 2013 at 7:28 am
P.S. I just found that I can set up a SQL Server alias, to a named instance of SQL Server 2005 (also on my PC), and access this alias from...
December 10, 2013 at 3:44 pm
Hi,
I did something akin to this, I'll tell you what I did, see if it helps you at all.
I used an MDX statement to calculate an aggregated "worst value"...
April 2, 2013 at 9:35 am
Just a quick question - have you verified there aren't any firewall issues involved? One of the things we had to do, was make sure the firewall permitted the one...
April 2, 2013 at 9:19 am
Viewing 15 posts - 1 through 15 (of 15 total)