Ruby on Rails is one of the most popular web development frameworks, and a useful tool used by both startups and more established companies to build strong graphic user interfaces, and responsive websites and apps.
MS SQL Server 2008
Articles & Videos
Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.
this isn't real example of scenario but will hopefully help to solve
I have two tables, one a list of businesses and the other a list of categories. businesses are of 1 or more categories. I need t…
Could anybody explain what the issue is?
[ART.117.4012] Adapter Runtime (Adapter Service): Unable to run adapter service. Error occurred when connecting to resource Server1JDBCConnections:Ser
I have a test table with values inserted into it. I want to create and insert statement to insert all the values into a production statement based on what is in test. Is there any easy way to create …
I have a query that i need to save the results to a csv file and have that happen on a scheduled time. I want to create a sql job that will do this and overwrite the file each time the job runs.
The first block of code below is my cte statement, while the second block of code is my "main" query containing UNION syntax.
I need to place my cte clause within my main query, such that…
SQL 2014 Enterprise on Windows 2012 Server
SQL 2008 R2 on Windows 2008 R2 Server
I moved a database from the 2008 server to the 2014 server months ago. The 2014 server is a VM on VMware ESXi Host…
I need to find column values that contain any letter or special character. Basically I want to do the same thing as this regular expression - [a-zA-Z-&$!@#$%^&*()_+=]* . So is there an easy to do th…
I am trying to use the sql management studio import wizard to import some tables from excel.
I have SQL server express 2016 installed and Excel 2016 (e3) (see image of version below).
I'm trying to understands how do I use resource governer here to limit cpu or memory used when some queries are running or during the backup activities were perform.
I have so far created a w…
I have a table 'Table1' that has a Text Field that contains data like this:
1,1P0014.241102.0000 1053591503 5806909 1230 …
This one is driving me nuts... I know my way around Access pretty well and can manually translate simple queries to sql. However, in this one I have to include the same table twice (AS dbo_Job and ag…
Hello Experts Exchange
I have a SQL Server Reporting Services report that has a dataset with several columns, I want these columns going down as rows on the left hand side in a table, and my data fro…
I need to get the percentage of pass and fail
SELECT count(Outcome) as TotalCo…
After copying a database and security information to a new server, I'm trying to map a user ('UserX') to a database in SQL. However, when attempting to save, I get an error message: User, group, or r…
I have an application installed in Linux server which has EasySoft ODBC driver and this application connects to SQL Windows 2008 R2 server by ssl. What I try to understand is how it can connect…
I need to delete duplicate data
i.e. if i have 2 rows exactly the same, delete one of the rows
I have a table called Tbl_Data
It has these columns
When I execute the following stored procedure in SQL Server 2008, I get the error
Msg 102, Level 15, State 1, Procedure proc_CSL_AutoDetStop, Line 7
Incorrect syntax near '='.
Do you know how …
How do I resolve the following error using SQL Server 2008?
dtCreated has a data type of datetime and has a value such as "2009-08-03 00:00:00.000"
Msg 1023, Level 15, State 1, Procedure proc_CS…
I have an employer id value (12-3456789) totally 9 digit. I have this field as a varchar(10) in my DB.
I wrote my stored proc to pull this info for my report.
SSRS Expression I have is…
I have the following substring issue..and not working for me
So the DiscussionTypeNumber has a prefix of 3 characters that needs to be removed to join to the c.nid value.
I am trying to update the table. where I have following columns:
folioNo is the order
pgPos is either right or left (if folioNo is odd then put L (left) if even put R(right…
Windows Server 2003, SQL Server 2008, sp4.
max server memory (mb) = 61440
min server memory (mb) = 0
maxdop = 0
CTFP = 50
optimize for adhoc workloads = 1
Lock Pages in memory / awe enabled -…
Long way back, we had to take help from third party tools in order to encrypt and decrypt data. Gradually Microsoft understood the need for this feature and started to implement it by building functionalit…
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is a…
11,800 points this week
9,400 points this week
Zürich, Kanton Zürich, Switzerland
4,207 points this week
Pawan Kumar Khowal
Railway Road Gurgaon, Haryana, India
4,000 points this week
Harrisburg, PA, United States
4,000 points this week