I have a table with 1 lac rows with id and bit columns. The size of the table is 13.523MB.
If I add…
5 days, 22 hours ago
By: Adi Cohn
I have two databases: Db1 and Db2. For security (and other) reasons I don't allow the database user…
1 week, 1 day ago
as a adhoc DBA I have a unique request to assign non-admin user the ability to only view …
2 weeks ago
I ran into an issue parsing xml,
Here is a sample
<catalog issue="spring" date="2015-04-15"&g…
2 weeks, 2 days ago
By: Erland Sommarskog
Consider when ,userA begins transaction , does 'update','insert','delete' but commit transaction is…
By: IT researcher
Is foreign key constraint possible in xml data type?
Is it possible to mention multiple Foreign …
2 weeks, 6 days ago
By: William Rayer
SQL 2008 instance was running on a VM. It ran out of space so IT decided to shutdown and expand the…
3 weeks, 5 days ago
I am trying to run the SQL query mentioned below. The query executes within 8 seconds in Postgr…
4 weeks ago
While executing DBCC CHECKDB i am getting following error
"Check terminated. A failure was detect…
1 month ago
I have moved some of my database to SQL server 2017 (RTM) - Standard Edition from SQL server 2008 R…
By: Jeff Moden
I have an audit spec which covers inserts, updates and deletes on certain tables i.e.
Our database crashed this morning and went into recovery mode. Can anyone provide more details abo…
By: Gregory Lienard
Hi All. I Hope you can help me resolve this. I've already shrunk the tlog from 350 GB to 313.
1 month, 1 week ago
I have a field that coonsistently has data in this style: (b) Joe Brown -12563, (a) Mary Edwards -1…
1 month, 2 weeks ago
I am using SQL Sever 2008. I want to lock the whole table for insert/delete/update operation,but sh…
1 month, 3 weeks ago
Viewing 15 topics - 1 through 15 (of 30,194 total)
You must be logged in to create new topics.