How to find the all table list in the order of reference - Hi, How to find the entire table list in the order of Foreign key reference in a database ie. Parent table first,...
Get first date and last date of the current month base on Work Week - Hello all, Thanks in advance for any assistance you can give me. What I am trying to get is the first date...
Lock on SQL data rows - Hi, Can some one please help how can I acquire lock on rows while it is being worked by some one. My...
Conversion failed when converting the nvarchar value '/' to data type int. - I have SQL query as following : SELECT TOP (99.9999999) PERCENT CAST(CAST(LEFT(SpecialCode, CHARINDEX('/', SpecialCode) - 1) AS nvarchar) AS int) AS...
Error Processing Cube from SSIS package run as a SQL Job - Hi, I am trying to upgrade a SQL server with Analysis Services to SQL 2017 cu5, 14.0.3023.8, (I tried CU4 before...
Looking for some thoughts on design for db table renaming. - Basically, we have a 2 tables. One is being used by the app for querying (active), and one is used...
Linked servers on an instance all pointing to the local instance. - We have around 4 linked servers on an instance, each one of them pointing to a remote instance. These were...
Excessive Paging Continues... - We've been experiencing "excessive paging" for a while (per perfmon review). Application is sluggish. Added memory to the server (virtual machine), there's...
Violation of Primary Key Contraint - Hello, I am getting this error when executing my statement: Msg 2627, Level 14, State 1, Procedure ad_MissingStudentMasterData_Enrolled, Line 89 Violation of PRIMARY
General query intended to be Stored Prodedure using optional parameters - I intend to make a stored procedure that accepts several parameters and that has an option not to accept any...
SSIS data truncation. - I have a csv file which I am processing through SSIS. But there are companies in the list which have...
Logging options while running stored procedure - Hi I am tasked with building a stored procedure which performs inserts, merges, etc. What i have now is as follows. create...
Generate XML with name/value pair using FOR XML - Greetings, We have a vendor that is requiring that the XML we send them has name value pairs at the deepest...
Update Statistics script - I am looking for a script where I can update the statistics of the objects in a database if only...
Transactional Replication :: Error Creating New Publication - Attempting to create a new publication and received this error: TITLE: New Publication Wizard ------------------------------ SQL Server could not create publication 'XX_TABLES'. ------------------------------ ADDITIONAL INFORMATION: An...
SQL Server Agent can't start - Hello, I have these messages while trying to start the Agent. Knowing that a day before, it worked without any problems...
Any better way of querying multiple tables based on a column value? - Hi all,I often have situations where I have a table which stores, in two separate columns, a value and a...
Clustered PK perf - - Hi Experts, I have a doubt reg. the creation of a clustered PK for one of our DWH tables. Background - There's a...
ROW_NUMBER() OVER (PARTITION BY *** ORDER BY ***) excluding NULL values - Does anyone have an idea how to tweak the TSQL above to exclude assigning a row_number to rows for a...
Transpose a particular row to columns - I am seeing lot of examples of PIVOT to do this, but my problem is different. I have a table like...
