Browse the archive
Question I have created a 2012 WFC and SQL Server 2014 is clustered on it. The cluster works as expected but have a question on Users: I added a windows domain group to the cluster as sysadmin. When the user tries to log into SQL on the active server the …
Continue readingQuestion ReportserverTempdb logfile is 6TB in size and growing and I need help. I am supporting a huge reporting server farm and the client wants reporting services to be in AlawysON Availability group(AAG) and we configured reportserver and …
Continue readingQuestion I have a table that has a unique ID, name, email, and some other fields. I want to match this table against another table on email, but sometimes emails are shared. The unique ID is not shared among tables, but I will input the ID into the other …
Continue readingQuestion 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 …
Continue readingQuestion 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 a full script with …
Continue readingQuestion 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 is not reduced.
Continue readingQuestion 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 string.
Continue readingQuestion 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 …
Continue readingQuestion 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:
Continue readingQuestion I need to connect to a SQL Server through UFT (Unified Functional Testing) but the problem is SQL Server is present at different domain whereas QTP (HP QuickTest Professional) is present in a different domain. I am able to connect to SQL Server …
Continue reading
