Sql Server 2016 Installation Issue - Hi All, when i trying to install sql server 2016.iso file i am getting below error . Please give me solution for...
Kerberos issues and Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' - We have a linked server set up. It will connect with no problem, but it seems that we periodically are...
CONVERT DATETIME to TIME and remove seconds and milliseconds - Hello Folks, How can I convert StartTime2 so that it equals StartTime1 DECLARE @StartTime1 TIME SET @StartTime1 = '17:41:00.0000000' SELECT @StartTime1 DECLARE @StartTime2 DATETIME SET @StartTime2 = '2016-09-22...
Performance issue when testing the value of ROW_NUMBER in a WHERE clause - I have a (moderately complex) statement that performs pretty well. Adding a ROW_NUMBER() column to it does not significantly change...
Hacking the Report Server Database - Hi, Not sure if anyone has any advice here. I'm doing data driven subscriptions without enterprise edition and I've hacked together...
SQL Server Setup - I have installed yesterday SQL server 2012 SP1 with update enabled for SP2 on a 4 node cluster. Now i want...
Run a script file against Multiple databases - I have a script file in C:\Script.sql that I need to run against multiple databases. I can run on one database...
t-sql 2012 update primary key value into column of the second table - In a t-sql 2012, I want to place the new lockid values obtain from the first insert statement (for the...
Extract a uniform pattern from a file path - Hi All I have a strange problem here which I can't quite get to the bottom of. I have a file path...
How to Upgrade T-SQL Skills - Hi All, I'm a production DBA and have been for a good while. I can query, join filters but how do...
How to Make a SQL Query Run Faster - Hello: I know that this is a broad question. But, below is my SQL query code. I have tried running it, at...
sql query to display a trailer record at the end in txt file (using batch file) - hello, I want to display a trailer record at the end of records : the spec is as follows Trailer Record: Field Name Length Begin ...
sp_msforeachdb DBCC SHRINKFILE Query Problems - I was wondering if anyone could help me with the following (im trying to automate a way of shrinking all...
Anyway to connect to Oracle on the fly without tnsnames entry? - As the title indicates, I'm curious if anyone knows of a way to connect to an Oracle database from SQL...
SQL Server listening on multiple ports - Here is a question that has been posited to me. Can an instance of SQL Server listen for traffic on...
How to force column explicitly to string type before we export to excel - I have a package which laods data to excel ,but my manger wants to force column explicitly to string type...
Star Schema Design - Multiple Sources - Hi, I am planning the design of a star schema for a data warehouse. The data will be loaded from 2...
MDX Calculated Measures not affected by slicers - Hi! I'm new with this howl MDX thing and cant seem to figure out how to make the following work. I...
SSIS slow in Job Agent - Hi I have various packages which checks if a file is in a directory and if found kicks off the rest...
SQL 2000 cant not login using servername\Instancename - Hello, After sql server restart I've noticed that I [b]can[/b] login remotly only using: instancename instancename,port IP,port But [b]can not [/b]login using only: Instancename...
