Question : When benchmarking using sysbench and utilizing concurrency (multiple threads) for example on a table with 1,000,000 records, does […]
Author: admin
Best Practice For Data Views with Linked Server in SQL Server
Question : In SQL Server, I have to design a View that I can map on a DBML file in […]
How to save result from a Stored Procedure in a Linked Server to a variable or table?
Question : I need to read the results of a stored procedure in a linked server, and store them in […]
INSERT INTO statement with parameters for tableName, columns and values?
Question : Is it possible to have an SP that looks something like this: DECLARE @tableName = null; DECLARE @cols […]
Inserting data based on different conditons
Question : Though , i put my efforts in making question easy to understand , but i still dnt know […]
Add New Cluster node
Question : I have a Windows Server 2012 Failover Clustering Instance, hosting a SQL Server 2012 Enterprise Cluster, via NODE1 […]
Archiving tables with Access frontend and linked SQL Server
Question : I’m working on a project where the user has an Access 2013 MDB database with forms, reports, and […]
Table Data Space Used Confusion
Question : I have a heap table with around 700k rows. The rowsize is 34 bytes: (1x BIGINT, 2x SMALLINT, […]
Getting all databases which a sql logon can connect
Question : I need to know all databases in a SQL Server on which a user can connect. With sys.databases […]
Using UNION (ALL) in a WHILE loop with SELECTto merge the result set for each iteration
Question : When I am looping with WHILE in SQL Server 2012, if I use a SELECT statement it prints […]