Topics
Started by
Posts
Last post
Hi all, I was wondering how to monitor a database to ensure it's up. I have scripts that perform st…
8 replies
Hi, I'm investigating some strange CPU escalation / sluggishness of our server and noticed a number…
2 replies
When tuning a SQL query I don't bother with the Estimated Execution Plan. Instead I would use Actua…
3 replies
I have received vulnerability on Microsoft SQL server 2008 (RTM) > [high] [1433/tcp/mssql] TLS V…
1 replies
I am using the SQL Agent job to send alerts when certain conditions are met and I have a few bugs t…
2 replies
Hi everyone I have a table in SQL called dbo.ACTIVITIES which records the time it takes to complete…
3 replies
On the report a field is populated from a column X whose datatype is int. the problem is we don't i…
2 replies
Can anyone tell why command 1 is working while command 2 is not working? 1. exec xp_cmdshell 'copy …
7 replies
Hi, I really need your help with splitting an XML value into multiple rows by the top most element.…
3 replies
The Select stmt returns many rows but one column. I need to feed this value to using the master.dbo…
3 replies
I have a table (Messages) with XML stored as a varchar(max) column (Payload). The XML is formatted …
2 replies
Hi all, We have a client for whom we've designed a web application with a corresponding database ba…
6 replies
SET @EndDate = ( SELECT Max(d.End_Dt) FROM dbo.date d WHERE d.End_Dt < getdate() ) SET @Beg…
1 replies
I have this XML example below as an email message and I am having troubles getting all the deeper l…
4 replies
declare @rc int, @dir nvarchar(4000) exec @rc = master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE…
8 replies
Viewing 15 topics - 2,086 through 2,100 (of 30,225 total)
You must be logged in to create new topics.