Have you ever needed to find something in a stored procedure or function and found yourself trying to wade through syscomments? Ever want to know which views reference a table, but you don't trust sysdepends? BDS has released SQL Digger 2.0, a utility designed to help you search through your schema and code to find what you need.
2005-04-18
4,143 reads
A Longtime SQLServerCentral.com member and a very valued member of the community has just received a great honor in our field. Take a moment to read and add your congratulations.
2005-04-08
4,397 reads
Have you ever needed to find something in a stored procedure or function and found yourself trying to wade through syscomments? Ever want to know which views reference a table, but you don't trust sysdepends? BDS has released SQL Digger 2.0, a utility designed to help you search through your schema and code to find what you need.
2005-04-05
3,810 reads
With it's VizQL, Tableau Software is revolutionizing the way that you will analyze data. Built to work with multiple data sources, including SQL Server databases and Analysis Services cubes, this software will amaze you.
2005-04-04
3,531 reads
Are you looking for a head start on learning about SQL Server 2005? Able to get to Reading in the UK in May? One of the premier SQL Server MVPs, Itzik Ben Gan, is teaching a full day seminar on Advanced T-SQL, covering both SQL Server 2000 and 2005 on May 3rd.
2005-03-31
5,663 reads
Maintaining control of your schema with SQL Server 2000 can be cumbersome. However there are starting to be more and more tools to assist you with version control and tracking your schema over time. Nob Hill software has a tool that helps, which is currently in Beta and code named "Randolph". If you have a need, check out their new product.
2005-03-30
2,650 reads
SQL Server 2005 is coming soon and the setup team is looking for some feedback on their process. If you can spare a few minutes for a survey, they would greatly appreciate the time. And you will be helping others avoid the problems in the Betas.
2005-03-18
3,069 reads
SQLServerCentral.com tries to provide you a great deal of value for your subscription fees. We think we do a good job considering the $0 cost 🙂 One of the benefits we sometimes negotiate is a discount on products. DBXtra has generously offered a discount for the next few months, so read on and make your purchase today!
2005-03-11
2,895 reads
SQLServerCentral.com is starting a new contest, one where we'll have a winner every week as long as we can find prizes. Read on and see how you can enter.
2005-03-04
3,706 reads
The central place for Australia's SQL Server User groups and a list of their meeting times is now available.
2005-02-21
2,785 reads
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
By Steve Jones
I saw a question asking about the next sequence value and decided to try...
I've read a few posts regarding what we use to design DB models and...
I've got a table with 186,703,969 rows, about 300GB of data. There are several...
I created a SQL Database in Azure Portal but I've just noticed it also...
What values are returned when I run this code?
CREATE TABLE dbo.IdentityTest2
(
id NUMERIC(10,0) IDENTITY(10,10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
INSERT dbo.IdentityTest2
(
somevalue
)
VALUES
( 'Steve')
, ('Bill')
GO
SELECT top 10
id
FROM dbo.IdentityTest2 See possible answers