Topics
Started by
Posts
Last post
A topic I always get confused with is primary key vs. clustered index. I have an understanding of w…
12 replies
Dear Team, I am migrating from SQL 2008 to SQL 2014 for one of my app's.I have a SQL -> Oracle (…
6 replies
I appreciate it is utterly trivial question, and yet... When you have a small amount of columns, th…
8 replies
Hello everyone! I'm new a DBA and I was wondering if anyone could share some great experience in …
6 replies
I ran a report, outputting to TXT, but where does SSMS put the output file? thanks
7 replies
Code below works great, problem is I need to introduce variables in the openrowset update statement…
5 replies
I have a cursor which has calls a function (sorry for design this is a 3rd party db). Odd part …
2 replies
Hi From docs of MS, its not very evident, which SQL version (onwards) has Segment Elimination featu…
1 replies
Hi In 2014, In order to be able to do RowGroup elimination, we need "a particular column" to be in …
2 replies
is there a way to run command below in tsql, runs from powershell fine (xpcmdshell is on) exec xp_c…
2 replies
Hi, I'm getting an infuriating issue where I have my default collation of the server set to SQL_Lat…
6 replies
Hey All, I'm hoping to get some insight as to what could be wrong with this portion of a query I've…
10 replies
All, I am trying to implement a Try Catch in a stored procedure that contains multiple Update routi…
4 replies
Hi All, Looking to get advice on how to create a datetime field by combining int year and month fie…
6 replies
Hello, I am trying to use following conditions in my where clause but trying make sure that i ma us…
7 replies
Viewing 15 topics - 1 through 15 (of 2,591 total)
You must be logged in to create new topics.