Topics
Started by
Posts
Last post
So we are using the 64 bit version of SQL Server 2008. Form what I have read there is a problem pr…
2 replies
Hi All Without using Trace we need last week dead lock list for this any script please suggest us. …
4 replies
Hi all, I am trying to stored the output of sp_spaceused into a temp table as follow. if exists (s…
4 replies
I've been trying to come up with a good query/DMV to report on space used for the top X largest tab…
1 replies
Hi, I have a table (Users) with rows containing data about registered user, Table Columns: UserId,…
8 replies
I have a query that will run for a time period of 01/07/13 - 01/13/13 but will not run for 01/14/13…
3 replies
Hi Guys, Need urget help Please. I am running SP on SSMS everytime i run that SP getting Error "Ms…
21 replies
Hi, I have a stupid written query. I saw that 99% of the cost is going into key look ups... i tried…
6 replies
hi i have two tables table A main_table id fill_date 1 09/04/2003 2…
7 replies
Experts Table1 with fields: LinkField, NameField Table2 with fields: LinkField, OtherField I am tr…
5 replies
Hi All! Hoping someone can help us understand this. Given; USE tempdb GO IF OBJECT_ID('tempdb.dbo.…
4 replies
Doing this in SQL 2008. Is it possible to use the results of one column to calculate another column…
9 replies
Hey guys, I know there's been a few discussions on here about tally calendars and their use, I've g…
8 replies
Hi, I'd like to connect to multiple databases on different servers all from the same query. So, is …
7 replies
All, I have two queries like below. declare cursor c1... open c1 fetch c1 into ... while @@sql_stat…
4 replies
Viewing 15 topics - 4,486 through 4,500 (of 10,647 total)
You must be logged in to create new topics.