Concurrency - Please Provide Comments - Hi all I have a question about concurrency. Let me provide some set-up code first. [code="sql"]DROP TABLE IF EXISTS dbo.Test1 CREATE TABLE dbo.Test1 ( PK...
Bit of a rant - queries on space - Sorry this might be me ranting abit, but am prepared for someone to tell me I am being unreasonable hehe. So...
database features - is it always better to add database features like analysis services and integration tools and reporting services when installing sql server...
backward compatibility - do I have to install backward compatibility after installing SQL server 2014. And what is backward compatibility used for. And Can I...
Displaying Multiple rows clock event Under a different Column view - I would like to query the data were table output is by each row but i need need display the...
Very bad performance on a good HP DL380 Gen9 Server - This issue is something that I haven't had much luck trying to solve via on-line research, and was hoping to...
insert a new row(s) into sql table A from table B - Hello, I am using SQL Server 2014. I have two table the first one is Table_A and Table_B. I want to copy...
How do I install the Adventureworks database ? - TSQL - Folks I have the AdventureWorks2012_Data.mdf file with me. Will this be sufficient for me to install the DB on my local...
function to clean a phonenumber - Hello, I want a sql function that will allow to make one update but with several replace on the same column. For...
Can I do this? - Here is my brilliant idea (that I am sure someone else already thought of...) We have a situation where we regularly...
sql backup - Do you have any idea how long it might take to sql backup for 600 gb. Thank you
Selecting from two groups - Hi, I am having issues with the following script. I have 3 tables that link together. What I need to do...
Aggregate Different Values - Hi Gurus, Just wanted to seek out for your help. This is a bit opposite of what aggregation should be. :hehe: I...
Get information about people who are free on a particular day - Hi, I have the following data with me: CREATE TABLE Table1 (ID varchar(10),StudentName varchar(30), Course varchar(15) ,SECTION varchar(2),DAY varchar(10), START_TIME time , END_TIME...
Big data: transfer x-number of rows per batch? - Hi all, I must transfer a big table (231k rows not that big, but 735GB big because of blob) to another...
SQL Backup running long - Hi Guys, Can you give me a guideline as to what to check what caused my backup to run for a...
Looking for way to dynamically replace street suffix with abbreviation based on tables - I'm working on creating a unique address list, but many of the duplicates come in with Street one time and...
Next Identity needed - How do you get SQL Server to assign the next identity to a query? I am getting a NULL not...
Counting field values per day between specific date ranges - Hi All, thanks in advance for any help. I have a table where I store holiday bookings, one row per booking....
Parameter on Powershell Script - I'm having some problems sending parameters to a Powershell script when it includes a dash (-) in it. Here's an example...
