Question : I need to have a way to insert to a table, fast, synchronous, with minimal duration. What I’ve […]
Tag: sql-server
Unable to Query Very Large Table
Question : I have a table defined as: CREATE TABLE [dbo].[DataTable]( [ID] [bigint] IDENTITY(1,1) NOT NULL, [Data] [varbinary](max) NULL, [Preview] […]
Why should I create an ID column when I can use others as key fields? [duplicate]
Question : This question already has answers here: Closed 10 years ago. Possible Duplicate: Why use an int as a […]
Query execution time is random, need to identify the root cause
Question : I have a query like below select * from table1 where column2=123 and column3=’B’ Now the issue faced […]
How to script out push subscription creation at the subscriber?
Question : I’m trying to set up a push subscription to a SQL Server publication from the subscriber. I could […]
2 similar queries in large sql server table – 1 takes too long
Question : I have a huge table in my database that contains distances between cities. This enables my application to […]
Select data from another database instance on the same server in sql server
Question : I have a query shown below: select count(*) as Count, datepart(yyyy, [LogDate]) as [Year] from ViewAssociate..Auth_Log where ActionCode […]
Is it possible to get server roles and database roles in a same query/script?
Question : Is it possible to get all database roles and server roles in the same query/script? if so then […]
UPDATE performance where no data changes
Question : If I have an UPDATE statement that does not actually change any data (because the data is already […]
MSSQL Geography STIntersects returns 1 when 0 is expected
Question : I’m experiencing an MSSQL Geography issue I can’t explain. Assume that I’m math-challenged, but it seems like the […]