Why is this happening? - It's SQL Server Management Studio 2014 http://imgur.com/SlWjziv http://imgur.com/cSVP2IY
Convert Value Returned by Row_Number() Function to Text Based on Relationship to Overall Result Set - I'm using the SELECT below to pull a list of parts and rank them by the number of times that...
TSQL query to get employee name from employee table by using id from user table - How to write a sql statement that can get the name from employee table by using id from user table...
Need help with shrink - Hello experts, I'd like to setup a job that will take a log backup, and then shrink the log file for...
Where to start? - I've just installed SQL Server Express 2014 on my development machine, and I'm looking at the Management Studio Object Explorer....
Count patterns of behaviour in a certain order - Hi, I'm looking for a method to count the number of people in a dataset of Peoples Actions who have completed...
SQL upgrading values in XML - I have created code similar to below. This is slow since this is a very large table. Is there a...
played for high stakes and it is believed - [url=https://www.reddit.com/live/wotyzd6amnrc]Barcelona vs Real Madrid Live Streaming[/url]
remarkably similar to modern football - [url=https://www.reddit.com/4d2gbv/]El Clasico 2016 Live Streaming[/url]
often on important professional - [url=https://www.reddit.com/live/wotbt75j7iyk]El Clasico 2016 Live Streaming[/url]
By date - I would like to run for 100 days of data. getdate() - 6 april 7april - 14 april and so on.. How can I break into...
Processing strings. - Hello Processing strings. Examples are replace, DelimitedSplit8K. And lots more. What is a good way to process the string, but not process the...
"##MS_PolicyEventProcessingLogin##" errors - I installed the Oracle 11g client on my (Windows 2008 SPK2/SQL 2008 R2) and set up a Linked server to...
DDL Trigger for Preventing Sysadmin roles. - Hi All, Can some one provide DDL Trigger script to Prevent Sysadmin Roles. Regards, Shenkar Gade
drop temp table owned in another session - Almost silly question that I'm curious about. Can I drop a local temp table owned by myself in another session? I can't...
Creating a Dynamic Temp Table - We know that a statement like 'SELECT f1, f2, f3 INTO #temp FROM Table1' will create a temp table called...
Oracle BETWEEN DateTime statement - Hello, I've connected to a new database at work via VBA. I've entered SQL script into my VB code and it...
Complicated performance issue - Hi All, We have 2 live environments both with same database structure and application but there is a big difference in...
installation issue-services - Hi all could you please suggest what is the error in installation,all the services are installed but i am unable to...
why i can't shrink tempdb data file - Hi, my tempdb database is 30GB(datafile). i try to shrink it with all those options but no luck. use tempdb go DBCC SHRINKFILE (tempdev,5000) go DBCC SHRINKFILE...