UPDATE table SET columnB = columnA --This will update every row. UPDATE table_name SET destination_column_name=orig_column_name WHERE condition_if_necessary --This will update rows which satisfy the WHERE clause UPDATE table1 SET column1 = ( SELECT column2 FROM table2 WHERE table2.id = table1.id ); Whereby: table1 = table that has the column that needs to be updated table2 … Continue reading Copy one column to another sqlserver
How to prevent users from accessing SQL Server from any application or any login expect your main application & its login
When a user who isn’t in the logon trigger exception list above tries to connect, they will get this error.
Cannot connect to SERVERNAME.
——————————
ADDITIONAL INFORMATION:
Changed database context to ‘master’.
Changed language setting to us_english.
(Microsoft SQL Server, )
List all Highly Fragmented Indexes in SQL Server
Mining Twitter Data with Python (Part 1: Collecting data)
Twitter is a popular social network where users can share short SMS-like messages called tweets. Users share thoughts, links and pictures on Twitter, journalists comment on live events, companies p… Source: Mining Twitter Data with Python (Part 1: Collecting data)
Did You Know?? R Services is in Standard Edition of SQL Server 2016 — The SQL Herald
While my last post extolled the virtues of SQL Server Standard Edition, this week while doing some client testing with Microsoft, I learned about another key standard edition feature. The new SQL Server R services is supported in standard edition of SQL Server 2016. While you won’t get access to some of the cool functions […] … Continue reading Did You Know?? R Services is in Standard Edition of SQL Server 2016 — The SQL Herald
Kill All Sessions Coming from a Host in SQL Server
Kill Sessions by HOST SQL Server --Check no. of sessions coming from all hosts connected to DB -- SELECT hostname, COUNT(hostname) FROM sys.sysprocesses P JOIN sys.sysdatabases D ON (D.dbid = P.dbid) JOIN sys.sysusers U ON (P.uid = U.uid) WHERE hostname != '' GROUP BY hostname ORDER BY COUNT(hostname) DESC; -- Create Procedure to kill sessions … Continue reading Kill All Sessions Coming from a Host in SQL Server
SLOB Sustained Throughput Test: Interpreting SLOB Results
SLOB Sustained Throughput Test: Interpreting SLOB Results.
