Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.
MS SQL Server
Articles & Videos
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
We have got a basic query that we run on a daily basis that works really well. However we now want to format it into a HTML table.
Im new to the SQL statements and have got the below so far
Hi Experts I get following Error
Updating a record
**** SUMMARY ****
MESSAGE: 'The record cannot be deleted as 'Agreements' contains related records'
LEVEL:1 TYPE: 'System.Data.SqlClient.Sql
System: Windows Server STD 2012, SQL 2008 STD.
I rebuilt indexes using the maintenance job in SMSS.
It finished with no error.
I checked fragmentation after it(Code to check fragmentation is a…
We have a logon failure occurring each day at about the same time. The failure is occurring because the login does not exist on the SQL Server. I notified the developer who's machine it is coming fr…
I am looking into a PowerShell script to achieve this
Copy a file from a local server path: c:\PurchaseInfo\PurchaseDe
I have to log …
I have a trigger on a table (like an audit trigger) that updates a backup table whenever the main table is updated. If someone updates the main table "Client", all the changes are captured along with …
I am trying to SELECT all sys.messages that contain the text string 'NULL'.
First query shows there is at least 1, message_id = 515.
Second query does not return this record. I assume there …
I'm not an expert on SQL, but have to rebuild index and update statistics on a database.
When I search the steps to do, nearly all of them are running manual codes to do it and they are all differ…
I need to provide some information to IT about.
I am not sure, how I can generate this information?
i. OR RTO
ii. OR RPO
iii. DR RTO
iv. DR RPO
Is there any query or script that I ca…
I have a membership database. One of the fields is "Email". That field CAN be blank. I'd like to query the database and find all member records with no data in the Email field. That we can reach o…
I have an app where I am creating users and one part of the app and if the user exists then I want to return a 0 and if they dont exists then return a non 0.... A 1 would be fine!!!!
Anyway heres m…
We have centralized database (SQL server 2000) where data gets consolidated from distributed databases (databases on remote branches - SQL Server 2008). Two of the remote branches are failed as the da…
My code works when using tables in another Access Database however I get this error after moving Tables to SQL.
The line is:
Me.netcharge = Round(DSum("NZ(hxdchge,0) + NZ(imhandchge,0)", "invoiced…
I want to write a sql statement giving me the most recent date when a customer paid for different products by product
Result should be like this
Customer ='James", last_date_paid_for…
I have a table named table1 which has the names of customers inside.
In table1 and table2 I have unique customer id which I can use when I copy customer names,
I want to copy all the names from ta…
Running SQL Express 2012 and have created a database "Admin_Data".
Using ODBC connection I can connect to the system databases but get an error on the "Admin_Data"
Could anyone share the steps involved during DR drill for failing over the log shipped databases and app team is gonna do some tests on the secondary database(which will become primary …
i have a issue in importing bit values in to database using SqlBulkCopy
Creating object of datatable :
I want to script out the SQL server Import and Export task. See the attached image. If I don't want to use the Wizard, just wrting the script, do you know the fast way to do that? AM I able to script …
I have a table. I want to insert a huge records into it. For fast performance, I want to know if I should set up an index, is better or completely no index is better?
How to have a script to commit…
I've downloaded and installed ApexSQL and my menu looks like this:
ApexSQL Source Control
Neither of those two pulldowns list the Text Search function and that is what I need.…
Hi Experts ,
Lot of Internet solutions are trying to create a Data table first and map the column SQL bulk instances and try to import the CSV . What if i have 30 to 40 columns . Do i need to all t…
Good afternoon. I am just starting to play around with SSRS. I have a report I created from a SharePoint list (if that matters). I have two date fields once called created and the other called complet…
I've been given 13 different spreadsheets that are currently used for tracking our companies contracts. They look like they were created by 13 different monkeys. No consistency between them, no data …
Perplexed by SQL Server date styles (http://msdn.microsoft.com
The purpose of this article is to demonstrate how to retrieve data from an Excel sheet and put it in a table in a SQL Server database. Introduction Anyone who's ever used a computer for a sig…
Zürich, Kanton Zürich, Switzerland
30,495 points this week
Gandhi Nagar H O, Gujarat, India
17,104 points this week
Pawan Kumar Khowal
Railway Road Gurgaon, Haryana, India
16,832 points this week
11,832 points this week
9,800 points this week