Topics
Started by
Posts
Last post
Guys, I have the following CASE statement which I would like to replace with a table because A) It…
4 replies
Hi ALl I have a view which looks something like below. Select * from T1 with(NoLock) Inner Hash Jo…
12 replies
Hey guys, I have an ssis package where I have a staging table with the rows that need to be sent to…
1 replies
We have a CLR function we use to calculate returns (specifically yield) on a set of financial asset…
3 replies
Hi expert, How to add LoginName, ApplicationName, HostName on select * from sys.procedures to find …
3 replies
Please see the attachment
3 replies
I have the task to convert our company reports from query embedded reports to stored procedures. So…
17 replies
Hi, I need the ChildID column values to be inserted as a separate row . CREATE TABLE #MyTestTabl…
2 replies
Sql Server 2012 Enterprise 64 bit 500 GB of memory. Netapp SAN for data. Should I be concerned ab…
6 replies
Hello , I have an application that reads data from a database, How can i use the profiler to pull …
3 replies
It might be obvious for all here, but I wonder where should I place NOLOCK, when several joins and …
26 replies
In a sql server 2012 database, I have the following 2 tables: 1. CREATE TABLE [dbo].[Orders]( …
3 replies
I am trying to search a column in a table for non-alphanumeric characters (.,% etc) so I can report…
19 replies
I have the following query where a column A can be the same but I have an order in which I want the…
4 replies
I am starting to learn to use Extended Events and it seems like it has a lot of very useful element…
2 replies
Viewing 15 topics - 1,471 through 1,485 (of 4,984 total)
You must be logged in to create new topics.