Stack Exchange

Question I have a table that is several hundred columns wide. Is there a way to convert each row into a single concatenated string with the column title included without having to list each single column in the query? I’m doing this because the columns … [Read More]

Question I’m a web developer and I want to export a database to work on it in my local machine. I’m using generate script with data. the script is generated but without the linked servers used by some Views. Is their a way to generate … [Read More]

Question I am working with a 500 GB SQL Server database. I need to reduce the size of the database data file after removing a large amount (50%) of the data. I tried re indexing, it’s good the database has de-fragmented. But the DB size … [Read More]

Question I am trying to pull all data where a sale date is >= to a certain datetime. When I execute my query I get an error of: Msg 241, Level 16, State 1, Line 15 Conversion failed when converting date and/or time from character … [Read More]

Question I’m designing a MongoDB database for an Uber-like application, but since I’m new to NoSQL concept, I have several doubts. I have three main collections – users, requests and messages. User can post a ride request, and if other user wants to give him … [Read More]

Question I have AlwaysOn Availability Group setup for my SQL Server. Now I would like to configure SSIS. How do I do it? Below link provides some information but since I am not DBA it’s difficult to understand this article: AlwaysOn Availability Groups and SQL … [Read More]

Question So the default location for databases on our server is c:\program files\microsoft sql server\mssql11.mssqlserver\mssql\DATA but due to space limitations we instead use d:\data I have now since corrected the default location to be d:\data However I am unable to move a database that was … [Read More]