Tag Info

New answers tagged

0

Assuming the availability of an index to provide the requested sort order (SomeColumn ASC) the sample query you posted will in all likelihood take a row lock, even where the index in question is not covering for the query. The query processor is smart enough to know that reading a single row from one end of an index (possibly followed by a lookup to ...


0

Replication will automatically move data from one instance to the other and leave both in a read/ write state. Replication will resume if the connection is dropped. Of course when you delete the data from the remote site you don't want to replicate that action to the central site, too! If you choose to roll your own a SQL Server Integration Services ...


0

It's an internal table that is used during the import of a bacpac. If all is well it should be gone when the import is done. If it remains in the database the import wasn't completed successfully.


1

My diagnosis from the information that is currently available: Sounds like your tables are for whatever reason mostly uncached. The first run brings all data into cache. The plans probably have tons of random IO. This is extremely slow to run on a disk, and almost unnoticeable in memory. Therefore, I guess that the new edition does not provide you as much ...


1

Until we see the actual code, we can only speculate but for what is worth, I'll do a guess. Assuming that your code involves only a table and its columns (no @variables involved) and is something like: UPDATE tablename SET column_a = column_b, column_b = 0 WHERE (condition) ; It is valid SQL and 100% correct. Correct, meaning that ...


1

Using NOT EXISTS should work, eg SELECT * --!!TODO add column list FROM dbo.CompanyDomains cd WHERE CompanyId = @CompanyId AND NOT EXISTS ( SELECT * FROM @domains t WHERE cd.Domain = t.domain )


1

What I'm totally stopped on is I don't see any equivalent of a List is SQL. Is there a way to build all this up in a list? So a list in SQL Server is basically a table. You can use table-valued parameters to pass in your complete list from C#. You basically just create a table type to define that list you are passing in, see the example in the MSDN ...



Top 50 recent answers are included