Issues with Power query in SSIS and SSAS 2017 (New Experience …
Aug 5, 2019 · SSIS supports Power Query as a Source, but do not seem to support M code using a function.
Getting the counts and comparing with the inventory table
Jul 10, 2014 · Without DDL no one can execute any query. How to get DDL: Right click on the table in Object Explorer and select script table as CREATE. Post these create table scripts …
Get definition of an index from query in SQL Server
Oct 10, 2012 · I need to get definition of an index using query in SQL Server 2008 as we can get definition of a stored procedure using sp_helptext command.
The replace function requires 3 argument (s).
Dec 21, 2012 · Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/ MS SQL optimization: MS SQL Development and Optimization MS SQL Blog: Large scale of …
SQL Server slow after rebooting windows server
May 27, 2020 · The software connecting to the SQL server gets very slow and every transaction has a delay for like 0.5 sec which is bad. Now, when I log onto Windows Server 2019 and …
Foxpro in OleDB query - social.msdn.microsoft.com
Jun 3, 2008 · Then i use OleDB query's to run the first functionline behind the "LOOKUP1" which inserts an T or F based on the data in the CONTACT field, T if contact is empty and F if its not …
stored procedure for rebuild indexes - social.msdn.microsoft.com
Oct 11, 2012 · Question 0 Sign in to vote hi all this is my rebuild index query, i schedule it in sql server agent (jobs),but it getting failed my stored procedure here :
How do I turn on Stored Procedure headers?
Apr 8, 2010 · Premature optimization is the root of all evil in programming. (c) by Donald Knuth Naomi Nosonovsky, Sr. Programmer-Analyst My blog Marked as answer byEd Price - …
Restore Database - Script - social.msdn.microsoft.com
Jun 19, 2012 · I want restore more database at sql 2008 EE with sql script, start with. The backup databases are stored at on hard disk.
how to write inner join sql query - social.msdn.microsoft.com
Oct 6, 2011 · you want to join the two tables, you can write the sql like this: select name,age,sex from employee inner join department on employee.departmentId=department.id if you want to …