FT should never run as a domain account? - Hi: Is there any restriction like why the Full Text Search should need to run using "NT Service\MSSQLFDLauncher" and not preferred...
Current Quarter - Hi Guys, I am using the below which does the following. Show the data for the current month unless today's date...
Shared stored procedure with very complicated input - So, the basics of what I want to accomplish is simple...I have a stored procedure that has some really complex...
Find a backup to rstore from takes 'Forever' - Hi All! As a part of me development tasks, I have to restore databases frequently from devices - local harddisk. Most times it's...
Can I rename the Primary Key of a replicated table ? - I have a very well established merge replication structure of 7 subscribers around a single publisher with many replicated tables. ...
Slow query - client or server issue - If seeing a client make a regular query that uses the same plan but completes in radically different times on...
SQL In-Place Upgrade Issue - I inherited a SQL 2014 machine and am trying to do an in-place upgrade and when it gets to the...
pass table param - How do you pass a table like this? ;WITH TestTbl AS ( SELECT * FROM myTable ) CREATE FUNCTION Ex( TestTbl TableType READONLY) RETURNS VARCHAR(MAX) AS BEGIN DECLARE...
Does anyone use views in this way? - Hi, I know there are several cases where we as database developers need reference tables to help us with our querying...
MSSQL Schema Export Only - Is there an easy way to do schema only exports in mssql
Trigger to notify when mssql job is disabled - I have a trigger that will let me know when a job is disable or enabled how do i add...
decimal places correction - Hi All, I want my numbers to be converted from a column which is of nvarchar(100) datatype to decimal(18,2). How can I...
Unusually Expensive Deletes - Hi all, I have a scenario on a few of our servers that I can't quite explain that I'm hoping someone...
Choosing the Birthday of a Customer by month? - CREATE TABLE birthdays( cust_id INTEGER NOT NULL PRIMARY KEY ,cust_fname NVARCHAR(50) NOT NULL ,cust_lname NVARCHAR(50) NOT NULL ,cust_dob DATETIME NOT NULL ); INSERT...
Help with code to Grouping the text in multiple lines - Hello everyone I am a newcomer to the world of TSQL and was wondering if someone can help me with the...
Stock take FiFo conundrum - Hello, I'd very much appreciate some advice/help with a stock take problem. I've had a look at https://ask.sqlservercentral.com/questions/1961/the-fifo-stock-inventory-sql-problem.html but my scenario differs somewhat....
Scheduling jobs in Azure SQL database - Azure automation or Elastic jobs for EXPORT and IMPORT of a table? - Have recently created a database in Azure SQL database and I'm quiet new to it. Requirement - Have to export a table...
Good to have Multiple Data Warehouses? - Interesting debate came up on data warehousing. Is it good to have multiple data warehouses or just one? To add some...
filtering using strtoset - Hi, i have the following MDX query that uses parameters from an SSRS report to produce a result set: WITH MEMBER...
Table Design - Dear Experts , Please share if there are any standard guidelines for designing the table objects , apart from Normalization , and Column...
