Advise on AlwaysOn new feature - direct seeding - Hi Guys, Seeking advise. 1. Once AG is setup with automatic seeding, whenever i create a database in Primary, i need to...
tempdb data and log file - Hi, We have some reporting queries which use tempdb very heavily and I get alerts from monitoring tool, that temp db...
Windows Defender - Hi, I was trying to figure out whether or not to keep Windows Defender turned on or off on our database...
Session Context In SQL Jobs - I have setup a job to test if session context could be used across job steps. From what I can...
Compilation lock and blocking - Hello, We are seeing compilation lock blocking on one of our production server. Initially we saw it was because of the...
Actifio? - We are in the middle of implementing Actifio as our backup strategy. Obviously as a DBA I'm reluctant to relinquish...
SQL Server Multi Administration Job not appearing on target server inquiry - Hi, Can anyone help me on this inquiry that it seems there was no error on job creation but not appearing...
How to archive old data from sql database - I have some data being written to a sql database, by requirement I need to retain the data for 1yr....
Removing Table Partitions - help! I have moved the filegroup to another table, dropped table, how do I remove the filegroup from the partition function...
Unkillable session - alternatives? - 11.0.3381.0 SET SINGLE_USER WITH ROLLBACK IMMEDIATE hangs indefinitely According to sp_who2's LastBatch column it hasn't done anything since 6th February (dm_exec_requests says...
How to join these tables together - How to join Employee and Student tables with HR table, - using ID and date columns to join with effective dates...
SQL Server 2008 R2 CPU Blunted Spikes - Hi there, I'm looking for suggestions for statistics I could monitor to discover what could be causing the cpu "blunted spikes"...
subquery - this is my query select Students.student_rollno, marks, Subjects.subject_name ,Subjects.subject_id, Gradetype.Grade_id, TheoryPractical .ThPr_name, EndtermProgressive. ETPA_name from Students_Subjects_junction join Subjects on Students_Subjects_junction.subject_id...
INSERT into table with 5 billion rows - Hi there, I have a table that archives a process. Here's the table structure CREATE TABLE dbo.temp( NULL, ...
Create From and To dates - Hi, I have the @rent table as below which holds the tenant rent charged values. The table has inconsistency as there...
Stored Procedure execution - Hi, Below is the scenario. CREATE PROCEDURE SP_MAIN AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT...
No PKs on fact tables - I just inherited a data warehouse where none of the fact tables have a primary key (all fact tables are...
Failed to notify ''operator name'' via email? - Following command sends email fine: EXECUTE msdb.dbo.sp_notify_operator @name=N'operator name',@body=N'test message' However, SQL Job with a notification to above operator doesn't work. Job history...
Importing Stored Procedure execution in excel - New Columns not showing up - We have a stored procedure which we use to import the data in Excel using following vba 'With ActiveSheet.QueryTables.Add(Connection:=Array(ConString1), Destination:=Range("A1")) .CommandType...
Search for string in stored procedures excluding comments - Anyone have a script that will not only find instances of a string in stored procedures on your db (easy...
