I'm seeing a number of these - is there a way to find out what object they are waiting on and shoul…
8 months, 3 weeks ago
By: Gail Wanabee
I have a single Win R2 2008/64Bit/7.50GB of RAM SQL Server 2012 running and am using a WebApp runni…
3 years, 9 months ago
I would like to know if all procedures in DB are used or not respectively.
Is there any l…
3 years, 10 months ago
I have one sql query which has many joins and quite complex .
The same query working fine on…
3 years, 11 months ago
By: Sudhakar G
Hello, Is anyone know any tools that you can copy one server to another. We have 3 servers: Product…
4 years ago
I have a database and a table in this database has 1000000 rows. I have this database to my …
This one's for the gurus out there.
I am a pretty darn experienced SQL developer. This prob…
4 years, 2 months ago
This is an odd one I just ran into today. I rebuilt an older query that aggregated together a…
I haven't seen this before, and I can't seem to find what to search on to find an answer. What cond…
4 years, 3 months ago
Still have a number of servers running 2000 and have one particular poorly performing stored pr…
4 years, 4 months ago
I created a table with a single varchar(10) column and ran a select statement against it. In Profi…
4 years, 5 months ago
I am simplifying a proc we have that we cannot use half of due to not having enterprise edition …
4 years, 7 months ago
By: Rob Reid-246754
As a .NET web-developer, I find myself producing lots of stored procedures and functions (SQL Serve…
4 years, 10 months ago
By: Gail Shaw
The below cursor is running very slow and I am noticing a lot of PAGEIOLATCH_SH wait states. I hav…
By: gconte 55278
I understand it is possible to index a view in SQL2000.
I have an old legacy system that has th…
4 years, 11 months ago
By: Steve Jones - SSC Editor
Viewing 15 topics - 1 through 15 (of 2,578 total)
You must be logged in to create new topics.