An evaluation copy of SQL 2016? - Not too long ago I downloaded SQL Server 2016. I was certain that I had downloaded the Developer Edition, which...
SQL server service pack,hotfix applied dates - Hello, Found Powershell script in below blog to list the last install date and time for windows updates on servers. https://gallery.technet.microsoft.com/scriptcenter/4d70947e-21b1-4a45-9d78-a7198ed55cca Is there...
Need help with SQL query - Hi All, I'm pretty new to this and am in need of some help writing a query. I'll try to explain. I...
Table Replication. - I have a mirror in place. since i don't have enterprise edition i need to do maintenance(index rebuild offline, Gather...
Exclude the data starts with ING - Hello, how to write a query - to exclude the field that starts with ING select * form table where ID NOT LIKE...
Overlapping datetime ranges. - Overlap in ranges. I have a set of data,rows which a start_time and a end_time. Each row should get a New_starttime, so...
Is there a matured solution to ETL excel data? - Merry Christmas and happy new year! From time to time my work needs to deal with lots of excel sheets from...
SQL database recovery from corrupt database file! - Last week I backed up my SQL Server by using BE 2012. I named the file "SQL Server BAK" which...
Issue with column parsing - Hello, I have data from two different sources - Source1 and Source2 - we have a dtsx package where it loads data...
Compare two tables and insert the differences - Hello, I have two tables -- Table A in Server A of Database A -- Table B in Server B of Database B My...
Using Large Integer Or GUID Vs Using Small Integers For Primary Key - Hi all, Would using UserID column (GUID) or BankAccount column (9 digit integer) as the primary key column be less...
Plan Guides -- depend on "as clause" alias? - I'm trying to use plan guides to help some bad ORM queries ( hinting option(recompile ). Now I see that nearly identical...
How can I query it fast ? - I have a few million records in a csv file. This has only one field which is a driver md5 ( eg....
RAISERROR - Stored Proc wrapped in sqlAgent job - hi, This is a classic scenario of an SP wrapped in a sqlAgent job and despite SP failing to do its...
Bitwise & NULL - I have a large number of yes/no columns for a table. Rather than creating a bit field for each, I'd...
Parsing paired relationships. - Hmmm... OK, I can do this but only with some really expensive RBAR table operations, the script I've written takes...
Update had to be done in two steps, Why? - Originally I had this query: Original value for starttime is 1800001 (Clarion time figures based upon 1/100 of a sec since...
xp_cmdshell heartaches - I have a sub folder on my 2008 sql server listing backup files. All I want to do is store...
SSIS - Export multiple SQL queries to one excel spreadsheet - Hi All, I am using SSIS and I am trying to export 3 separate SQL queries to one excel spreadsheet. These...
Incremental refresh and error recovery question - I am refreshing a warehouse table nightly. The refresh is designed so that only when all the tables are successfully...
