Topics
Started by
Posts
Last post
Hi All, I've been trying to make the following query more performant by breaking it up into smaller…
16 replies
I have come across a database system which isn't designed to work optimally. It is fairly large (~4…
11 replies
Hi I have a table dbo.CustomerServices with over 10 Million Rows I have none unique Indexes on Cus…
11 replies
Hi everyone, I have inherited a job that is calling a maintenance plan. The maintenace plan makes …
5 replies
Hi, How to convert Oracle @ISMBR function into SSAS MDX Query?. I tried like IIF( Count( Intersect(…
1 replies
I have a sproc that will generate a dynamic call (and this must be done in a stored procedure),...…
16 replies
I just used the SSIS data profiling task and exported data into an xml file. How does once get that…
2 replies
I just started working at a software company that has never had a DBA. The database that evolved o…
60 replies
Hi, We have a high volume database with 1000's of users and 1000's of procs. Our application enforc…
4 replies
I overheard someone helping a user fix their query where they had used = NULL instead of IS NULL. …
5 replies
Hi All: I have a CTE query against a table with 32K rows that runs fine in 2008R2. I am running it …
5 replies
Hi there, I have the following table struction, lets call it table A. bookidstartdate endate 2…
10 replies
Hi There, I need to group up the records randomly into ‘n’ number of batches. That can be done by N…
2 replies
I have the below table : IDName Date_StartDate_End Time_StartTime_End 9xx…
3 replies
The other day I was asked to build a SQL Server process to terminate blocking sessions that could b…
3 replies
Viewing 15 topics - 2,581 through 2,595 (of 3,067 total)
You must be logged in to create new topics.