Topics
Started by
Posts
Last post
Hi, I am trying to get sizes for replicated tables with a script, two extracts are below (one for p…
1 replies
I ran: Update HumanResources.Department set Name = 'Doctor' where DepartmentID = 1 and then ran: SE…
7 replies
Hi Firstly may I say that the sproc I am having problems with and the service that calls it is inhe…
6 replies
Is there a scenario whereby you would create a stored procedure with the option Set Xact_abort ON A…
3 replies
I am creating a report on an asp.net webpage to show how many times a coupon has been used from a s…
5 replies
Hi, I have this statement: SELECT top 100 P.LastName , P.FirstName, P.MiddleName, P.Practitio…
5 replies
I have a need to create a line graph report in SSRS 2008. The report should show the top 10 servers…
2 replies
Hi, I have a table with hundreds of millions of records and need to update an xml column to null. I…
1 replies
Hi All, I am sure such queries would not be complicated for you guys and available all over the int…
6 replies
I have three sprocs and three tables. I was told to use a clustered index in the first table and a …
4 replies
Hi I have been trying to the query optimizer to generate a parallel execution plan but no matter th…
11 replies
I am currently reading through Itzik Ben-Gan's "Microsoft SQL Server 2012 High-Performance T-SQL us…
5 replies
Hi, I have a statement that I'm having trouble converting: select * from emails join InternalContac…
2 replies
I have a table that holds product prices. It was originally designed to hold historical price value…
5 replies
Hi All, I have a table called dbo.PhoneCalls with below columns PhoneID |PhoneNumber| Callstarttime…
3 replies
Viewing 15 topics - 1,351 through 1,365 (of 10,647 total)
You must be logged in to create new topics.