Viewing 15 topics - 12,511 through 12,525 (of 284,036 total)
Topics
Started by
Posts
Last post
Having a table with 100 columns and 1 million records. Select Count(*) from Mytable; COUNT(*) ----…
18 replies
I have DB which is set to Full recovery model and looks like the current transaction log file size …
18 replies
In another forum post, a poster was deleting large numbers of rows from a table in batches of 50,00…
18 replies
Hi , I've got a peculiar problem with my VCENTER's SQL 2008 database. My Database is running on SIM…
18 replies
Comments posted to this topic are about the item Dropping indexes
18 replies
We are finally setting up everything for a massive migration of all 2005 systems to 2012 with a "ro…
18 replies
I am running SQL Server 2012 on an i7 Windows 7-64 PC. Lately I have noticed that when I execute a…
18 replies
I have a column in the table with datatype DATE Gives data in the format YYYY_MM_DD How can I go ba…
18 replies
Hi I have one stored procedure which in turn executes 3 more sps in it. All the 4 stored procedure…
18 replies
Comments posted to this topic are about the item Gratitude
18 replies
I just got a table with 16736580 records. Index is created. A test shows a query like select * from…
18 replies
Hi, I have created a function which is returns a Sql query as string [nvarchar(max)] I want to exec…
18 replies
We are getting a security audit for the company I work for and got this question recently, and whil…
18 replies
I am looking for an elegant way to return top n and sum up the rest, in my case CTE/temp table/vari…
18 replies
Dear Sir create table Hierarchy ( ParentID int, ChildID int ) go insert into Hierarchy values (101,…
18 replies
Viewing 15 topics - 12,511 through 12,525 (of 284,036 total)