Look up dynamic SQL on this site. Be sure to do the following: Reasons to be reluctant or/and mindful of dynamic SQL can be found here. Do read it. http://www.sommarskog.se/dynamic_sql.html 'The Curse and Blessings of Dynamic SQL'
2005-04-05
This, like many other tools seems to be a great decision support tool. However the "gotcha" in decision support is not in the tool used to present information. The real pain is in the actual data analysis and classification. I have been a first-hand witness to a company pouring out millions of dollars trying to find […]
2005-04-04
hey thanks for your replies - Aaron - sorry i did nto mention that there is a PK field called UniqueID.
2005-04-04
2005-03-25
Hi All,We want to upgrade our SQL Server 2000 from current Build 780 to the latest build. Can some advise what the latest build is and where I can download the fixes?Thanks a lot,Yichang
2005-03-23
Aha, found it: Index --> Create Procedure:nIs a placeholder indicating that a maximum of 2,100 parameters can be specified.
2005-03-22
How about this code???? Use Modelgoexec sp_configure 'allow', 1 reconfigure with override go declare @sid varbinary(85) select @sid = sid from master.dbo.syslogins where loginname = 'sa' update master.dbo.sysdatabases set sid = @sid where dbid = db_id() exec sp_configure 'allow', 0 reconfigure with override I successfully ran this against my MDSE Instance and was able to change the […]
2005-03-18
Hi,Please make sure that you don't have any empty spaces. Did you check the database compatibility. Hope it is 80.If the database compatibility is 60,65,70 then probably you have some other setting to look for. I've noticed that if you specify a nonexistent database name, it returns an empty result set instead of returning an error […]
2005-03-17
1 reads
Good article, but I'd have to disagree with the following:"Non-Clustered indexes are better for singleton and individual row lookups. "Non-Clustered indexes really aren't any "better", they costs virtually the same (an index seek vs and clustered index seek) during selects. And when ordering is necessary they can drastically improve performance.One of the subtle things about SQL […]
2005-03-16
Domain A trusts domain B. A user in domain B can access sql if this specific access is set up in sql but a user in a group in domain B can not access sql even if the group is set up in a sql login.
2005-03-16
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers