I have a maintenance plan that is set up to back up all of my 5 DB’s every day. I do not need to backup them all, only part of them. I don’t want to create a new job as my website is old and I don’t want to make significant changes (moreover, I am […]
I have a table below that I need to see if interest rates changed for any loan number within a given period. Below is just sample data, I need to find this information across 2 million rows. How can this be done? Sample data +————+————-+—————+ | DATE | LOAN_NUMBER | INTEREST_RATE | +————+————-+—————+ | 04/01/2010 […]
I have a database which is in XML format contains both structure and data but I don’t have database to import the data from XML. Is there any way to import the XML file into SQL Server, so that SQL Server will read the XML file and subsequently create table structures and insert the data […]
It’s a bit annoying that SQL Assistant shows “autocomplete” window on each , or . button press. Actually I don’t need it’s assistance in most of cases but still would like to have it’s features enabled. So I don’t want to switch it off (suspend), but’d like it to show me autocomplete window only when […]
Say, I have a huge transaction with multiple save points defined at different intervals. Is there a command or tool that I can use that will provide me a list of the names of the savepoints that I have defined in my script.
I have a column that stores 2 values. Example below: | Column 1 | |some title1 =ExtractThis ; Source Title12 = ExtractThis2| I want to remove ‘ExtractThis’ into one column and ‘ExtractThis2’ into another column. I’ve tried using a substring but it doesn’t work as the data in column 1 is variable and therefore it […]
I try changing primary key constraint, but get the error saying: “The index is dependent on column”. I tried dropping the index but it seems to do nothing. Am I even doing drop the right way? If no, is there any way to get specific index name? Also here’s the link to previous question for […]
I am unable to connect to SQL Server using SSMS 2014/2012. But able to connect successfully using DBVisualizer. Getting below error: Connecton Timeout Expired. The tmeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in tme. The […]
I’ve recently upgraded SSMS 2014 to 2016 and what’s bugging me is that whenever I want to quit it, it always asks me to save Solution even though I didn’t create one. How do I disable this check?
I have three tables, T1, T2 and T3. T1 has the three-dimensional primary key of (T1K1, T1K2, T1K3). T3 has a one-dimensional primary key of (T3K1). Between T1 and T3 there is an n:m relation represented by T2. T2 has a one-dimensional primary key of (T2K1). T2 references T1(T1K1, T1K2, T1K3) via (T2T1K1, T2T1K2, T2T1K3) […]