Topics
Started by
Posts
Last post
is this the best way to concate the date and time field in terms of performance of the query? creat…
7 replies
Hi I have a simple Pivot table query that lists customer services, this is used for to make reporti…
7 replies
DECLARE @MaxPartitionNumberToPurge int DECLARE @MinActivePartitionNumber int DE…
6 replies
Hi All Here i am little bit confuse i have query with join condition and i need to apply an index f…
3 replies
If i have the following table CREATE TABLE [dbo].[Visits]( [Id] [int] IDENTITY(1,1) NOT NULL, [Da…
2 replies
Can anyone provide me an information for creating an index for the below mention query . Thank you …
4 replies
I have a name field that I'm trying to retrieve the suffix (JR, SR) from. I have a table of valid …
4 replies
Hello Everyone I am in need of a way to concatenate values that have matching ID's and SubID's and …
3 replies
Hi, I want a code for how to create a seperate function outside,i have a parameter in my pr…
1 replies
Hello friends, I am in the middle of tuning a query and need your advice on this. The first look at…
6 replies
Hello, I've created one SQL Server profiler template to catch all deadlocks/locks in a specific dat…
2 replies
I’m under a big deadline for a customer, up most of the night, and I have a T-SQL script that aggre…
21 replies
Hi All, DB: SQL Server 2008 R2 Enterprise OS: Windows Server 2008 Enterprise (on VM) I have a view …
24 replies
Hi guys There is an application in my company which imports files inside several tables on database…
17 replies
Hi All, I want to import around 100+ excel files into SQl Server 2008R2, is there a simple way of d…
5 replies
Viewing 15 topics - 7,141 through 7,155 (of 10,647 total)
You must be logged in to create new topics.