Topics
Started by
Posts
Last post
Hi All, I have a query that has me completely baffled. This query is part of a third party applicat…
4 replies
All I am fighting to get a PK change from Non-Clustered to Clustered, with more vigorous testing th…
18 replies
By: RonKyle
We are using SQL Server 2008 Standard Ed. Every night we update our master databases with informati…
2 replies
Hi, I run a query from Excel to pull the data from SQL server and I have created another worksheet …
4 replies
We have a database server and an application server. On the db server is a sql job calling up an SS…
2 replies
Hi I'm in the process of re-initialising one of publications which has a very very large table. wh…
6 replies
Hi all, We have repartioned a server (create a larger C-drive/system partition). It's about Windows…
2 replies
declare @sql nvarchar(MAX) SELECT @sql = (SELECT 'UPDATE STATISTICS ' + quo…
7 replies
By: MadAdmin
BMC_CORE_BMC_BaseElement.Name, BMC_CORE_BMC_BaseElement.instanceid, BMC_CORE_BMC_BaseElement.recon…
2 replies
Hi, I am working with deadlocks. In my current environment, we have around 330 GB database. We are …
1 replies
Hi there, I need to recover some data in a table but i'm not 100% sure the right way to do this saf…
9 replies
We push data out to an SQL ODS. Some of the ODS tables keep a history of changes of records from t…
6 replies
I have used the XQuery.modify('replace value of...') statement before using a static string value a…
2 replies
Forgive if this is a foolish question, I've seen the various articles that suggest using stored pro…
3 replies
Hi guys, I'm getting the following error message 'An aggregate may not appear in the set list of an…
4 replies
Viewing 15 topics - 4,291 through 4,305 (of 30,225 total)
You must be logged in to create new topics.