Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 5536

All versions of Microsoft SQL Server (not MySQL). Please also add a version-specific tag, like sql-server-2016, since it is often relevant to the question.

5
votes
1answer
For development/testing I set up replication in SQL Server 2012 RC0 (11.0.1750) using the default permissions on the agent, and I'm getting this error: Message: Access to the path 'C:\Program File …
asked Jan 5 '12 by influent
0
votes
1answer
I've seen this bug before and I don't know what made it go away in the past. I have a test server that has three jobs that each kick off their own SSIS package. In production this works fine and the …
asked Feb 9 '18 by influent
0
votes
0answers
I have two primary instances of SQL Server, one for OLTP and one for reporting. The data warehouse for reporting is basically a Type 2 SCD: every table has DWDateStart and DWDateEnd columns and the ro …
asked Dec 22 '14 by influent
1
vote
I determined that SQL Server's IsDescendantOf function is way too slow (at least in my environment) and a CPU hog so it wasn't an option for me. I used this to create a CustomerHierarchy table: http: …
answered May 16 '12 by influent
3
votes
4answers
I have a scalar function that traverses a simple parent-child hierarchy of customers to find the ancestor that's in charge of billing. Here's a simplified version of the schema. CREATE TABLE Customer …
asked May 11 '12 by influent
1
vote
2answers
I have a logging database with a few lookup tables and one massive event table that has 79 million rows. On busy days my code inserts over 3 million rows, so the event table would be enormous in produ …
asked Apr 23 '14 by influent
2
votes
1answer
My main production server has four NUMA nodes with two SQL Server 2012 instances on it. One of the instances has the CPU affinity set to use only one NUMA node, and sys.dm_os_nodes reflects that corr …
asked Jul 16 '14 by influent
1
vote
Found the answer: http://blogs.msdn.com/b/sql_shep/archive/2012/06/21/sql-server-2012-license-core-limitaion.aspx My consultants installed the wrong version (CAL instead of core), so it's limited to …
answered Jul 25 '14 by influent
0
votes
I found the fix but I can't explain what changed to make the fix necessary. I added the "SYNCHRONIZED" parameter to the package parameters of the Agent job step and then the job acted normally, waiti …
answered Feb 13 '18 by influent
3
votes
1answer
I have a SQL Server 2008 R2 failover cluster with a passive node and an active node. The servers are physically identical. I have two instances of SQL Server, one set to use all the CPUs in the firs …
asked Jan 16 '13 by influent