RE: Dynamic SQL problem
Don't make me feel < snip and switch to my online dictionary> embarrassed </snip>
2004-11-19
Query
Cannot add domain group
Hi folks. I have not seen the following before: I cannot add the security group ‘domainname\LADM SLEEC DEV’ as a login to SQL Server which complains that the group does not exist. If I use Enterprise Manager and attempt to add the user, I can see that the group does indeed exist in the domain… Now, […]
2004-09-27
RE: how to reset the primary key restraint
Alternatively, after performing the delete, go into EM, design table and set the Identity Seed of the primary key to something else (eg 2) and click on Save. Then set the Identity Seed back to 1, Save again, and your numbering will again start from 1.
2003-12-15
1 reads
RE: saving XML stream to a file
Well, that will work. However, I am getting this error message below. Cannot open output file - c:\xml\mscunits.xml No such file or directory The file and directory structure exists on the machine that QA is running. Is there something with xp_cmdshell or QA that needs to be modified in order to get it to execute […]
2003-12-08
1 reads
RE: using IN and a list of values
I am still curious about your 75 Million rows I would like to know the performance of the query posted using sp_excecutesql @str with the hard coded numbers in @str. My guess is that for such a big table a recompilation of the procedure using harcoded numbers will be the fastest option! can you post […]
2003-12-05
RE: Storing arrays in SQL.
My guesstimates are that this database, including indexes, will already amount to 1/2 terrabyte in size. Now if I included that schema for coping with arrays, god knows what size it will reach. With some tables with an estimated 500,000 records, that will then need 1,000,000 records in an array table at least. Database sizes […]
2003-07-31
2 reads
RE: "Not enough storage is available to process this c
Typically I've seen this error when one of the memory pools (but not total server memory) runs out. For instance: http://support.microsoft.com/default.aspx?scid=kb;en-us;172281 Are there any error messages in the Event Log? K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
2003-07-17
RE: Backup Debate...
My vote is first goto disk then tape. tape is slow and you'll never make your 6 hour window.
2003-07-09
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers