Topics
Started by
Posts
Last post
Is it possible to have a stored procedure or script that I can run which will generate a script in …
8 replies
I am migrating an Ingres database to SQL Server. This database has 260 tables to migrate. I usually…
5 replies
Hi All, Select count(*) from table1 is taking around 5 mins. table is having 4035938 rows. can anyo…
9 replies
Hi, We are getting the following deadlock and can't figure out how to resolve it. The parame…
3 replies
Thanks for the assist and i appreciate any help that is given. Trying to do some automation of a b…
2 replies
I have the following query IF OBJECT_ID('tempdb..#StudentScore') IS NOT NULL DROP TABLE #StudentSco…
2 replies
Hello there, it feels like a surprisingly basic question. In the update statement below we have a f…
7 replies
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
Hello everyone! I'm new a DBA and I was wondering if anyone could share some great experience in D…
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 is…
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
Viewing 15 topics - 481 through 495 (of 3,067 total)
You must be logged in to create new topics.