SQL 2016 SP1 CU2 - sudden and unexplained shutdowns - Hi there, Anyone had problems with unplanned instance shut-downs on SQL 2016 SP1 CU2? We patched our Data Warehouse to CU2 in...
Performance regression after SQL Server upgrade - HI All, I am currently in a situation whereby i have migrated 2 databases from SQL Server 2008 to SQL Server...
Stored Procedures for document Numbers - CNCB 17 1 CNPO 17 1 CNCP 17 3 PRT 17 5 POD 17 7 SCT 17 8 EMAIL 17&
SQL Streaks - Hi I wish to calculate several flags for the streaks in SQL I have added the tables and the desired table I...
query table with child-parent hierarchy with history - I have different tables that work with child-parent hierarchy, this is easy with just a "parent" column that indicates to...
Splitting TempDB - Hi, I noticed yesterday that I have the following setup for one of my production virtual database servers: 1 socket, 8...
Using Lead And Lag Functions As A Means Of Navugating Back And Forth In A Recordset - Hi Guys, I have been doing some reading online and discovered the Lead and Lag Functions. According to what I have...
General advice needed - database design - Is this a bad way to design a pricing table? - Suppose we are selling bottles of water that can be bought in sizes of 1 to 10 litres (1, 2,...
Reasons to have Mirroring AND local backups? - Hi all, One of my clients has both of these for the same server. For my own understanding I'd like to...
How to find all procs in a DB which cross reference other databases - Hi All I need to find all procs from a database which reference tables from another databases. all my DB has...
Integer to Big Integer and foreign keys - We need to convert an integer column to big int in the EVENT table. Since the PK ( event_id ) is found...
Cross Apply Timing Out on Large (1bn rows) Table - I have a small table Members (1000 rows) that contains member information. I have a large view History (1bn rows) that...
How does a stored procedure takes 15 seconds to start? - The trace attached shows a stored procedure calling another stored procedure. The statement calling the inner procedure takes 18 seconds while...
What's the best way to get a sample set of a big table without primary key? - This is what is happening here: We have lots of big data, table's size is often around billion and there is...
SQL Server Transactional Replication and Reinitializing a subscription - The Production Publication Database is very large and is running on SQL Server 2008 R2. The Subscriber Database is in...
How much memory does SQL server Really need? - Hi All, How do we know how much memory does
CPU troubleshooting with Perfom counters - I have put 2 PERFMON counters to troubleshoot high CPU utilization due to SQL server 2008 on a windows host...
How can we load more than 6 million records into excel sheet - Output of the new report will be more than million records (ex : 6 million records) Could you please check how...
SSIS CopyObjectLevelPermissions broken? - I have scoured the internet but cannot find a definitive answer. I need to copy the users/roles and object level...
How to find a post from “My Posts” quickly? - If there are hundreds or thousands posts, do I have to go through the whole list page by page? Can we...
