CLR Error - I do not know (at this time) what version of SQL Server is actually involved as I am waiting for...
Page File Optimization 2012 sp4 - Hi All, Can you please explain about how to do Page file optimization? Does it require sql restart.? What factors should I...
SQL Query Delete top 4000 rows when row count > 10K looping to reduce row count to 10K - Need a maintenance query for an alarm logging table to see if the row count is more than 200K rows...
DT_BYTE to DT_DBDATE - I've got an SSIS project pulling data from a MySQL database into SQL Server. One of the date values in the...
How to study the layout of a database? - Hello friends, Suppose you download a sample database, whether it be AdventureWorks, Northwind, or whatever other database. What steps do you...
WITH (NOLOCK) vs READUNCOMMITED proper way / performance differences - Good afternoon everybody, I need help from the Community. For the purposes of this post I do not worry about dirty reads. In...
Database upgrade and migration to 2016 SQL Server - I am looking for pointers on what option to take for high availability for a new SQL Server 2016 environment....
Trigger on saving a stored procedure or function. - We would like the act of saving a T-SQL procedure or function to automatically append the name of the programmer...
Finding the MIN or a group of values not used in a previous group - I have been having trouble finding anything on google because I'm not sure how to phrase the search. What I...
Compare top 2 transactions from 12 months from the current transaction date -
Recreating SSISDB - Hi Is it possible to drop and recreate SSISDB database.My collegue restored SSISDB to a new server and now all the...
Parsing First and Last Names from Full Name - Hi there! I have this code: SELECT CASE WHEN CHARINDEX(' ',name) = 0 THEN name WHEN CHARINDEX(' ',name) = PATINDEX('% _%',name) THEN RTRIM(SUBSTRING(name,...
DB Corruption - Hello, One of the teams at my place of work came to me with a problem with one of their SharePoint...
Pass SSIS parameter into Agent Job - Hi The problem: I am calling a stored proc from VBA which executes a stored proc. The stored proc triggers an...
Get Query used for update/insert/delete and log it with a trigger - I am trying to get the query executed to perform an insert, update or delete on a table, but only...
Insert with null - Hi I have a table called Remote_Item with some records like
how to find the lowest usage of a database - Hi Guys How do we find the lowest usage of a database ? I need to find the best time to ...
Databases using Reporting Server - Hi, Is there a way to see what db's are connecting to report server over the last 30 days. Hope...
parse string and check for valid date - I have a flat file with a bar(|) delimiter. It has no headers, but I want to check columns(11,12,13) for...
Convert VbScript Com object to PS to load sql2005 DTS pkg - Trying to Convert VBScript Com Object to PS. VbScript: Set objPkg = CreateObject("DTS.Package") objPkg.LoadFromSQLServer machine,,,DTSSQLStgFlag_UseTrustedConnection,,,,packageName objPkg.Execute PS: $DTSSQLStgFlag_UseTrustedConnection = 0x100 $dtsapp = New-Object -ComObject DTS.Package $dtsapp.LoadFromSqlServer( $server, [typ
