Topics
Started by
Posts
Last post
Hi, we have a database which should store different files (doc, pdf, XML ,...) with filestream. We…
3 replies
SQL 2012 AlwaysOn High Availability, how to Query last backup history from MSDB with 3 replicas Da…
1 replies
Hi All, I've been doing some testing with some of the new features of SQL 2012, and I've found some…
9 replies
Hi peeps, looking at using a MERGE on a table with circa 100 million rows. Will be using all three …
8 replies
Use selects to build syntax? For instance, the other day I had to build a variable based on some co…
12 replies
Just when I thought this was about the silliest thing I'd seen... I had someone using NULL as a str…
7 replies
Hi, I'm trying to create a unique id, it's easier to show than explain i think... So I need the res…
5 replies
I recently moved the location of the tempdb databases to another drive from the C: to F: following …
2 replies
I am trying to run dynamic SQL, which will kill all sessions with particular login on remote server…
6 replies
Not sure why but any suggestions? Select Distinct M.Memid, M.Fullname, E.enttype, EK.planid, Ek.Car…
4 replies
The system I'm working on uses a lot of subqueries, and sums the results using UNIONS, which seems …
4 replies
Need a query help, on unpivoting columns Have the data as below... create table #Test (itemNo int, …
3 replies
I have a table with cols as follows ID Unit location col1 col2 userID 1 A AA a …
1 replies
Hello everyone I want to display the result of SQL result like Quick Search format. For example Bel…
8 replies
I have the following query where I need to set a variable to the value of a column in a row in a ta…
7 replies
Viewing 15 topics - 4,696 through 4,710 (of 4,984 total)
You must be logged in to create new topics.