Topics
Started by
Posts
Last post
This is a weird one. I have a periodic backup task, and when I need a development copy on which to …
5 replies
DECLARE @search VARCHAR(10); SET @search = 'dog,COW'; WITH T(C) AS ( SELECT 'Cat,Dog,Sparrow,Trou…
2 replies
Hello Experts I wrote a custom procedure to shrink the db log files alone. It works well always but…
1 replies
We see these errors and sql stops processing requests, we see a lot resource_semaphore waits at the…
1 replies
Morning all, I have a job which is extracting millions of records based on two views that pull acti…
2 replies
Team As per my requirment using below script to convert from varchar to numeric. declare @stg varch…
6 replies
A common partitioning scenario is when the partition column has the same value for every record in …
4 replies
SQL SERVER 2008R2 The number of files to retain for SQL Server Logs is set to 99. When I expand th…
1 replies
Hi everyone I have the following query: SELECT DATE, REGION, COUNT(*) as 'CountOf' FROM MyTable W…
1 replies
For reasons beyond the scope of my question, is there a way to run this command within a Stored Pro…
5 replies
I downloaded the script Adventure Works 2008 R2 OLTP script from CodePlex to create the AW database…
3 replies
I need to identify or flag the records that have an ApptDate that is <=7 days from the Discharge…
17 replies
My team is deciding to go with code-only solutions rather than continue our heavy reliance on SSIS.…
4 replies
One column (memberID) store about 100 member ID like below 000001 000002 ... 000100 How to code to …
7 replies
Hi All, I am having a Stored Procedure Or SQL Script to be attached to Job Scheduler. When this …
15 replies
Viewing 15 topics - 3,856 through 3,870 (of 30,225 total)
You must be logged in to create new topics.