A special thanks to Daniel Jones [daniel.jones.0543@gmail.com] for showing up interest and writing informative article for our blog (http://mssqlfun.com/).
Always on\Database...
2017-03-21
1,528 reads
The 11th cumulative update release for SQL Server 2014 SP1 is now available for download at the Microsoft Downloads site. Please...
2017-03-13
487 reads
Scenario: DBA found that tempdDBdatabase usage is getting high and most of the size is consumed by row versioning. DBA...
2017-03-06
2,611 reads
Issue: I am trying to load data from Excel 97 – 2003 sheet into a database table. I have written a...
2017-02-28 (first published: 2017-02-21)
4,866 reads
Restricting user to login from single host may be sometimes required from security point and other business requirements. We can...
2017-02-07
561 reads
Issue: While running powershell in SQL job step, I am getting below error: –
A job step received an error at...
2017-02-01
1,479 reads
Issue: When I am running code from PowerShell console its running fine but when I execute it through SQL agent...
2017-01-23
1,045 reads
1) As MS is kept increasing number of option while installation. To reduce no. of click, if setup pass Rules...
2017-01-16
567 reads
As per BOL (https://msdn.microsoft.com/en-us/library/ff878058(v=sql.110).aspx) : A sequence is a user-defined schema-bound object that generates a sequence of numeric values according to...
2017-01-05
481 reads
When you turn on this option, it will display the number of milliseconds required to parse, compile, and execute each...
2016-12-19
403 reads
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Hi, We have low latency high volume system. I have a table having 3...
Comments posted to this topic are about the item The Long Name
Comments posted to this topic are about the item Eight Minutes
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?